Dividing Pivot Table Count Value

[anthonycamilleri]

I am building a pivot table where I need to show the COUNT OF FIELD divided by 2. Any ideas how I might to about that?

 

[oldbrewer]

is the count field the only thing in the pivot table - and could you achieve your aim without using a pivot table

 

[ttray33y]

Power Query is free

 

[anthonycamilleri]

is the count field the only thing in the pivot table - and could you achieve your aim without using a pivot table

Yes, I need a pivot. My data structure is below. I just want to divide the 'Count of Project Ref' field by 2.