How to display values in pivot table

[#1]

Hi Everybody,

I want to display values which are not seleted but these are in table.

Such as I have two selection fields for year 1)Recorded Year (having values 2007,2008 ,2009,2010)

2)Contract Year (having values 2007,2008 ,2009,2010)

In this If I select 2007 in recorded year I want to show all values of contract year related to recorded year.Such as 2007,2008 ,2009,2010 of contract month(If no there is no values for 2008 and 2009 )Still I want to show those coloumns of contract rate(i.e.all years)

I had used shoe all values option but does not give me solution

Please anybody can suggest me

Regards

Go....COOL

[#2]

Did you try Show All Values on the Dimension tab? You want to modify Suppress Zero-Values and/or Suppress Missing on the Presentation tab. The results of those expressions when there is no data is either zero or null. The Suppress options hide zero and null values respectively. Try unchecking them to show the missing records.

[#3]

Nmiller ,

Thanks for your inpiut but I had already tried these options...

Can you give me idea about how to hide perticular row in pivot table (such as '-' containing row I want to remove)

[#4]

To hide a row in a pivot table, all expressions in that row must be null (-). Look at a record you don't want to show on your chart and make sure all values are null. If a value isn't null, then modify the expression, so it is null for those records you don't want to show.

[#5]

Hi Nmiller plaese check attached application for understanding

[#6]

Hi This is excelsheet for various approaches I had tried and problem description

[marcohadiyanto]

hi,

that's not subtotal,

you can try this:

go to your table, properties -> Dimension->support Month

and then setting for Selected dimension check 'Suppress when value is null'

regards,

Marco