Static dimension in Pivot table

[Anonymous]

I have the data as per excel sheet (static_Dimension.xlsx).

In script I have written the following

Temp:

LOAD [Product],

     City,

     //if([Date], Null(),[Business]) as ,

     [Business],

     Count,

    [Date]

FROM

[..\static_Dimension.xlsx]

(ooxml, embedded labels, table is Sheet1);

I have created the Pivot as below

When I select the date (from the list box) following is displayed.

But the requirement is that all the dimensions("Global", "Local", "Mumbai 1", "Mumbai 2") should always displayed irrespective of date selected (or any other filters)

OR atleast "Mumbai 1", "Mumbai 2" should always displayed irrespective of date selected (or any other filters)

[Anil_Babu_Samineni]

You can call your dimension which you want to restrict selection in set analysis. How is your measure looks?

[shiveshsingh]

Please check attached,

[Anonymous]

Thanks for reply. Can you please tell me what exactly changes are done

[shiveshsingh]

For business Dimension, tick mark Show All values check box

and in presentation tab, uncheck suppress Zero values.

Thanks

Shivesh