Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Sales on all lines

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

1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II

Thomas,

By MTH, FisYr I think you would want;

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

Regards,

Chris.

View solution in original post

2 Replies
chrismarlow
Specialist II
Specialist II

Thomas,

By MTH, FisYr I think you would want;

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

Regards,

Chris.

tmumaw
Specialist II
Specialist II
Author

Thanks Chris