Pivot Table Calculated Field Multiply by

[gavindavey]

Hi I have a pivot table below I not want to include a column beside each field multiplied by 430

All advise would be great

 

[RoryA]

Do you have Power Pivot?

 

[gavindavey]

Hi yea I have power pivot

 

[RoryA]

Then you can create a measure that counts category2 and multiplies the result by 430 - =COUNT(Category2)*430 basically.

 

[gavindavey]

Thanks RoryA

i have added the measure as below but this doesn't update the values how do I show in the table sorry new to power pivot

 

[RoryA]

Assuming it's visible in the field list, just drag it to the values area. If it's not visible, refresh the pivot.

 

[gavindavey]

Hi Yes I did think that's what should happen but not seeing it in my field list

 

[RoryA]

Are you definitely looking at the PP field list, not a regular pivot field list? Did you make the original pivot table using the data model?