![]() |
pivot tables: Calculated fields among *row* items
Hi all,
So I'm doing calculated fields among data elements, but is there a way to do calculated fields among row elements? So say my pivot table looks like this my have: Region | Data US Sum of Potatoes Sum of Apples Sum of Potatoes + Apples [<-calculated field] INTL Sum of Potatoes Sum of Apples Sum of Potatoes + Apples [<-calculated field] Is there a way to easily get [US minus INTL]? I guess this is essentially a different Grand Total summary. Thanks much. |
All times are GMT +1. The time now is 03:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com