Surpress when null in pivot table

[Anonymous]

Hi!

I trying to make a pivot table (example below) with two diemnsions.

Dimension2 Dimension1	aa	bb	cc	dd	ee	ff	gg
a	1	-	1	1	1	-	-
b	2	-	2	2	2	-	-
c	3	-	3	3	3	-	-
d	-	-	-	-	-	-	-
f	5	-	5	5	5	-

What I am trying to do is to show all rows from Dimension1 at all times, but to surpress columns when I have null values. Any ideas?

Thank you!

[hari8088]

Hi,

In Chart properties dimensions tab select  "Suppress when value is null" option for particular dimension.

[Anil_Babu_Samineni]

What is your measure? You can limit the measure over expression..And need to suppress from presentation tab?

[Anonymous]

I am losing row "d" when it is checked under Dimension2.

[Anonymous]

I have multiple exresions. But one of them is a modification of sum( {1} 1) . Otherwiise I am losing rows rows with null values then filters are selected

[Anil_Babu_Samineni]

Here is the issue? May be attach your application if you feel +ve

[Anonymous]

Sorry, I can't do that. But I can answer to questoins to help to understand the problem.

[Anil_Babu_Samineni]

Instead of writing stories, It's easy to make a note over application. Anyway, You can explain to rending the ouput