Forum Discussion

Lizabeth Stevens's avatar
Lizabeth Stevens
Copper Contributor
Aug 17, 2018

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 zero. If I use count, it errors.

 

If I copy the pivot table data and paste as values only, I can add the calculated field and everything works fine. But then I'm unable to add filters and/or slicers.

 

Any help is greatly appreciated.

  • Hi Lizabeth,

     

    You may add the measure assuming you added your data to data model

    =COUNTA(MyTable[MyField])*0.75

Resources