Excel pivot table

[shai123]

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

[#2]

Hi @shai123 ,

can you show your problem with the example, It will be more easier to solve the problem.

[#3]

@Vinit_Joshi 

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%

[#4]

@shai123 

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.