Calculated Field / Item

[guptamols]

Hi, I have the below data and i want to calculate score. As of now, i calculate this after the pivot area. Can i calculate it inside the pivot using calculated field / item ?

Transaction Id	Region	P1	P2	P3	P4	Good	Score
A989	KAR	1				FALSE	75%
A789	KAR	1				FALSE	75%
A900	KAR		1	1		FALSE	50%
A968	GUJ					TRUE	100%
A455	GUJ		1			FALSE	75%
A456	KAR					TRUE	100%
A910	GUJ	1			1	FALSE	50%
A915	GUJ					TRUE	100%
A457	KAR					TRUE	100%
A458	KAR			1		FALSE	75%

<tbody>
</tbody>

Pivot looks like below

REGION	FALSE	TRUE	Total
GUJ	2	2	4
KAR	4	2	6
Total	6	4	10

<tbody>
</tbody>

Have to calculate % TRUE as a score inside the pivot itself

 

[sgroath]

Inelegant approach but should give you what you are asking for...

Assuming Score is column H, put this in I2 and copy it down the column (you can format this as a %): =--G2

Expand your pivot table source to include the new column (which I called % True) and in your pivot table:

Drag % True to your values section
Select the drop down for this new field and select Value Field Settings
Summarize value field by Average and make number format Percentage
Hide the 2 columns that got added inside the pivot table showing Average % of True for both the TRUE and FALSE column labels (this is the inelegant part), keeping the Total Average of % True column