topic Sales on all lines in QlikView

Sales on all lines

tmumaw — Tue, 06 Nov 2018 15:48:03 GMT

Hi All,

I have a pivot table where I want to show gross sales on all lines to compare cost to sales. How can I show this?

Thanks

chrismarlow — Tue, 06 Nov 2018 16:05:18 GMT

Thomas,

By MTH, FisYr I think you would want;

sum({<[GL Hier 3]={'Gross Sales'}>}total <MTH, FisYr > Amount)

Regards,

Chris.

tmumaw — Tue, 06 Nov 2018 16:15:20 GMT

Thanks Chris