Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thomas,
By MTH, FisYr I think you would want;
sum({<[GL Hier 3]={'Gross Sales'}>}total <MTH, FisYr > Amount)
Regards,
Chris.
Thomas,
By MTH, FisYr I think you would want;
sum({<[GL Hier 3]={'Gross Sales'}>}total <MTH, FisYr > Amount)
Regards,
Chris.
Thanks Chris