Restrict Dimension

[#1]

Hi,

I have a requirement that pivot table is displaying the data for a Month (Week wise).. I have a week filter too. When I select the week filter (say week1 ) the pivot table displays only  the week 1  data  as i attached but I want all the week to be displayed and when i select week 1 , Week 1 value should be displayed and remaining (Week 2,3,4) should display Zero..

[jonathandienst]

Possibly (depending on your data model, dimensions and expressions) just disable the Suppress Zero Values option.

[avinashelite]

In the dimesnion tab >Check show all values and in presentation tab un-check the suppress null ..how this should help you

[Anonymous]

Hi Vivek,

Please check the below screenshot and try the following steps.

1. enable 'show all values' in dimensions tab.

2. uncheck the 'Suppress zero value ' in presentation tab.

[#5]

It is possible but it wont give away a good look to your pivot table, better show all the week values.