I would like to use the COUNTIF formula using the calculated fields option of the pivot table.
When I use COUNTIF on an excell cell, it works fine but when I use it within the calculated field of pivot table, there is a message error.
To detail a bit more, what I would like to do: i have a excel sheet with a column Vehicle where different Vehicles are listed and on another column totally independant from the first one, a 1 or 0 for presence of cars (not linked to 1st column). The goal is to make a pivot table which shows the number of time appears a car in the first column devided by the sum of values in the car column.
Vehicle car
Car 1
Truck 1
Bike 1
Bike 1
Bike
Truck 1
Truck

Hope somebody could help me on this

Good day budy!

Just read your post and think I have a quick fix to offer. I to use Pivot tables for a lot of my worksheets as a quick ways to manipulate huge sets of data to give me defined results. In your example you are trying to use the countif function directly referencing the fields withen the pivot table. I had this issue at first aswell. I find that the easy way around this is simply to take the data in the fields and mirror them in a couple of phantom columns and then use the funciones there.

So, let use your example:

Vehicle car
Car 1
Truck 1
Bike 1

....lets say "Car" is in A2, in C2 refernce A2 (make sure to type =A2 in C2 and not simply hitting = in C2 and then using the mouse to click the referance cell A2 because that will automatically give you the GETPIVOTDATA Funcion and that will make my work around not work at all)

....So now do the same for all the fields in your pivot table. This will create a mirror image of your Pivot Table next to it and now all you do is apply the formulas to this mirror not the actual fields and hide the mirror columns and voala!

When the fields values change so will your mirror. I know this seems very "simple" fix, but trust me, I was there and tried everything else and quite frankly this simply works and is above all accountable.

Hope it helps Buddy.