topic dived by Calculate Row data in QlikView

dived by Calculate Row data

Anonymous — Mon, 29 Sep 2014 13:55:34 GMT

I have below table and I want to add another filed % with EACH month Net revenue value should be divide by other row

"Month" and "GL name" are dimension and cost is calculated field

Please help me to get create formula

anbu1984 — Mon, 29 Sep 2014 14:21:56 GMT

Try this

=Sum(Cost)/ Sum(TOTAL Cost)

JonnyPoole — Mon, 29 Sep 2014 14:29:25 GMT

Combination of TOTAL and SET ANALYSIS:

sum(Cost)

sum( {$<[GL Name]={'Net Revenue'}>} total <Month> Cost)

I added some sorting and background shading to help you .

Anonymous — Mon, 29 Sep 2014 15:59:13 GMT

Thanks Jonathan Poole. It works well

JonnyPoole — Mon, 29 Sep 2014 16:10:13 GMT

Thanks for the note. Kindly close out the thread marking 'correct' or 'helpful' .