Sales on all lines

[tmumaw]

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 · Accepted solution]

Thomas,

By MTH, FisYr I think you would want;

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

Regards,

Chris.

[tmumaw]

Thanks Chris