Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have created a pivot table expression based on set analysis. The expression just calculates the average of sales for months > Mar-11, however in my model I have sales figures for previous years.
In my pivot table I get null values for the months pre Mar-11, however I want to hide these months in my pivot table. I have tried the usual suspects suppress when value is null and suppress zero values. I have two dimensions Month and a Market description.
Any help gratefully received. Cheers Darrell.
in dimension take
if(Month='Mar-11',Month)
and make supress null