May 09 2020 08:43 PM
I have an issue in excel pivot table, where in if i insert a calculated field in excel, the formula appilied to all individual field, but the it doesnt get applied to the grand total section. Is there a way to apply it to the grand total column. Because of this it gives absurd results like summing up of percentages
May 10 2020 12:04 AM
Hi @shai123 ,
can you show your problem with the example, It will be more easier to solve the problem.
May 10 2020 02:53 AM
Dear Vinit:
In the % yes column which i have introduced as calculated field in Pivot the grand total % cell totals up all percentage above it, whereas what i want is a percentage of 140/130 = 108%
Name | No | Yes | (% yes) - introduced as calculated field in pivot |
Sujay | 20 | 30 | 150% |
Vishak | 40 | 50 | 125% |
Ganesh | 70 | 60 | 85% |
Grand Total | 130 | 140 | 355% |
May 10 2020 04:05 AM
It slightly depends on structure of your source and how you calculate, but in any case for the calculated field if use any aggregation, not sum by default, Total will be incorrect. Better to use measure. For such simple model
add data to data model creating the PivotTable, and create measure as
It returns desired result.