I want to create a pivottable with the following values :
Number of days. This field is called "TEMPS"
count of the datacolumn "AUDIT". This was very simple; I put the field "AUDIT" in the values and change it to count numbers instead of sum in value field settings. This is simply a count of all the different values.
Here I'm using a formula. I want to calculate the value in TEMPS with the value of row 1: Number of Days * count of Audit. For that I created a simple formula: count(AUDIT)*TEMPS. I called this formula "DAYS". It calculates correctly.
Now I want to a a third row that divides Row 2/Row 1.
When I try now to add a formula: DAYS/count(AUDIT) it does not work.
I have even tried the simple formula count(AUDIT), wich I think should give the same result as Row 1, but gives me always the number 1
Are there any suggestions ?