Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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
Highlighted
Specialist
Specialist

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
Highlighted
Specialist
Specialist

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

Highlighted
Specialist
Specialist

Thanks Chris