i have a pivot table in which i want to create a new field via calculated field to subtract Max of Class from Min of sames Class. how to perform this task via Calculated field in pivot table.
i have a pivot table in which i want to create a new field via calculated field to subtract Max of Class from Min of sames Class. how to perform this task via Calculated field in pivot table.
It is not possible with calculated field. You will require additional calculation in source data or use simple formulas adjacent to pivot table.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks