Hello,
I have used from time to time the field option "Show items with no data".
However, most often I prefer to see no entry if there is no data.
Today, I would even like to go further: I would like to see no entry (row of column header) if the (all) data are zero for a given item.
Very often I have a lot of zeros in my PT, that I would prefer not to see.
And I would even more like not to see them on a pivot chart.
Do you think there would be a way to avoid the display of "zero" items?
Of course, I would like to do that without changing the original data base.
Thanks
I have used from time to time the field option "Show items with no data".
However, most often I prefer to see no entry if there is no data.
Today, I would even like to go further: I would like to see no entry (row of column header) if the (all) data are zero for a given item.
Very often I have a lot of zeros in my PT, that I would prefer not to see.
And I would even more like not to see them on a pivot chart.
Do you think there would be a way to avoid the display of "zero" items?
Of course, I would like to do that without changing the original data base.
Thanks