Pivot Table

[prabhas277]

Hi Experts,

I have one pivot table having 2 dimensions i.e year and code . now i need to hide the rows which are having no data for code dimension .

How i can solve it?

Thanks in advance..

[vcanale]

Hi,
Chart Properties, click on Code dimension and select Suppress When Value is Null:

Hope this will help

[prabhas277]

i did that still some more rows are there

[vcanale]

Tried to select "Suppress Missing" in the tab Presentation?

[vcanale]

or you can try to add the dimension Code as a Calculated Dimension:
=if(Code<>'',Code)

[prabhas277]

I checked that option also but still some more.

Is there any possible way to get that by using expression?

[prabhas277]

if am using If (code<>",code) then i am getting error..

[trdandamudi]

In the dimension for the code you can use the below expression:

=if(Len(Code)>0, Code)

Note: Make sure you select "Suppress when value is null" in the dimension tab

[vcanale]

which error?
..could you please post it?

[deepakkrish]

Check "Suppress when value is null"  to all fields in dimension tab,

at the same time check "Suppress zero values" in presentation tab for expression field.

check once