Forum Discussion
Excel: Pivot Table results based on COUNT - Issue with adding a Calculated Field
I have a pivot table that is based on the count of items (not sum). I'm trying to add a calculated field that takes the count and calculates 75%. If I use sum in the calculated field the results are ...
Hi Lizabeth,
You may add the measure assuming you added your data to data model
=COUNTA(MyTable[MyField])*0.75