AndrewCorkery
Technical User
Hi,
I have got a pivottable with two Sum of GrossInvoices and Sum of COGS fields in the data area of the sheet. I have also two other calculated fields GP$ and GP% that are simply functions of the two other data fields.
The problem is that I have selected for the Rows Grandtotal to be on and it sums the indivdual lines fine but when it comes to total the Grand and Sub Totals it just has 0 there.
On some Pivotables it works ie it will give the correct Sub Total and Grandtotals but on others it doesn't.
Any suggestions?
Thanks
Andrew
I have got a pivottable with two Sum of GrossInvoices and Sum of COGS fields in the data area of the sheet. I have also two other calculated fields GP$ and GP% that are simply functions of the two other data fields.
The problem is that I have selected for the Rows Grandtotal to be on and it sums the indivdual lines fine but when it comes to total the Grand and Sub Totals it just has 0 there.
On some Pivotables it works ie it will give the correct Sub Total and Grandtotals but on others it doesn't.
Any suggestions?
Thanks
Andrew