Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi,
Chart Properties, click on Code dimension and select Suppress When Value is Null:
Hope this will help
i did that still some more rows are there
Tried to select "Suppress Missing" in the tab Presentation?
or you can try to add the dimension Code as a Calculated Dimension:
=if(Code<>'',Code)
I checked that option also but still some more.
Is there any possible way to get that by using expression?
if am using If (code<>",code) then i am getting error..
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
which error?
..could you please post it?
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