Forum Discussion
Calculated items issue in pivot table
you just need to apply a value filter. Right-click on one of the "Clé de répartition" items and select "Filter | Value Filters..."
There you can filter on values the do not equal 0:
Hi Martin_Weiss, thanks for the reply.
Unfortunately, I can't do it the way you told me. I need to compute the variance between 2 columns and it doesn't work. Here is the result I have :
While I wish I could compute Réel - REF0.
I don't know if it is feasible.
actually, that's exactly what calculated fields are made for: making simple calculations between different columns.
Could you please provide more screenshots:
the list of PivotTable-fields and also what the calculated field looks like. So something like this:
It would be even better to have an example file with some random data uploaded, if possible.
Hi Martin_Weiss
And here is the formula I applied
Is this enough for you or you need more info?
Thanks a lot for the help
Hello Matthieu_Peters
thank you, now it's clear. You need to create a caluclated item instead.
Select one of the two column headers (Reel or BI), then goto PivotTable Analyze and select "Calculated Item..."
Then select the field Statut and enter the formular like this:
This should give the desired result, like in my example: