ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   pivot tables: Calculated fields among *row* items (https://www.excelbanter.com/excel-discussion-misc-queries/186534-pivot-tables-calculated-fields-among-%2Arow%2A-items.html)

[email protected]

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