Post reply

Matrix_Table Values Separe and sum

  • June 21, 2010 at 5:05 pm

    #224113

    Hi Please help me I am stack 🙁

    There is Only 3 Field On database (Process,Worker,Quantities)

    My Database like

    Process WorkerQuantities

    Sale, Smith,200

    Work Duration,Mati,12500

    Work Duration, Alise,10000

    Sale, Coe,300

    Sale, Sue,600

    Work Duration,Sue,12500

    Work Duration,Coe,10000

    Overtime, Sue,5000

    Overtime, Coe,3500

    When I make Matrix_Table

    it's like this

    WorkerSaleWork DurationOvertime

    Alise10000

    Coe30010000 3500

    Mati12500

    Smith200

    Sue60012500 5000

    THE QUESTION IS

    I add one more column on Matrix Table withOut Group And I want to Sum only WorkDuration+Overtime (this are not field on databese these are Process Data's)

    How can I do it?

    THANKS IN ADVANCE

  • June 22, 2010 at 3:04 am

    #1183161

    For that sum u can creat one data set, in data set u can write down like

    select

    '1' as id,

    (sum(case when Condition='true' the [Field Name] end) + sum(case when Condition='true' the [Field Name] end)) as new field name. to Place these fields , u have to add one more matrix on it then group by ID.

    i think this will help full for u.becoz we have designed same kind of reports.if find out any other way plz let me know

    Thanks

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply