L
Leo Demarce
I have a pivot table that looks something like this:
Customer CategoryA CategoryB TotalSale
TotalWeight
NetSale ExtWeight NetSale ExtWeight
ABC 1000 100 2000 100 3000
200
What I would ideally like to do is 2 things:
1, hide the ExtWeight column but still show the TotalWeight on the right
2, i want to create a calculated field on the right of the TotalWeight that
would be the average of the totalsale to totalweight (totalsale/totalweight)
which would be the avg sale/weight.
Any suggestions
Customer CategoryA CategoryB TotalSale
TotalWeight
NetSale ExtWeight NetSale ExtWeight
ABC 1000 100 2000 100 3000
200
What I would ideally like to do is 2 things:
1, hide the ExtWeight column but still show the TotalWeight on the right
2, i want to create a calculated field on the right of the TotalWeight that
would be the average of the totalsale to totalweight (totalsale/totalweight)
which would be the avg sale/weight.
Any suggestions