dont show column if measure value for max(date) in pivot table is null or 0
I have the following pivot table: I want that if the value in "area"=0 or is null, in the latest date (in this example in 01/29/2019) then it will not show this block name at all. which means, that in this case, I want to get a pivot table without block "Ranch7", because this block are in the latest date is 0.
if this is not possible, i would like to know if there is any option to color the background of the "area" for the latest date if there is null or 0.
Re: dont show column if measure value for max(date) in pivot table is null or 0
It's not possible. Every expression will be shown in a column for every dimension value if for any dimension value the expression has at least one non-zero value. The pivot table does not support text and background colors for expressions yet.