Hi,
Thanks for your post.
The idea was to find a functionality within the pivot table to hide zero values.
The difference from is not a formula cell is something that is part of the pivot.
On a pivot table if you right click, you get value field settings and then on the "show values as" you...
Hi everyone,
I have a calculated field by the pivot table called "Difference From". I did this, through the value field settings.
Now that I have the sales differences from one period to another, I wanted to hide zero difference values.
Can someone help me?
Thanks in Advance
Chirague
PRODUCT JAN FEB MARCH P1 P2 DIF
A $100 $250 $0 $250 $100 $150
B $0 $200 $100 $100 $200 -$100
C $100 $0 $400 $400 $100 $300
Hi friends,
This is an example of pricing differences by products and by months.
The objective of this report is to calculate pricing differences from the latest...