Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
In Chart properties dimensions tab select "Suppress when value is null" option for particular dimension.
What is your measure? You can limit the measure over expression..And need to suppress from presentation tab?
I am losing row "d" when it is checked under Dimension2.
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
Here is the issue? May be attach your application if you feel +ve
Sorry, I can't do that. But I can answer to questoins to help to understand the problem.
Instead of writing stories, It's easy to make a note over application. Anyway, You can explain to rending the ouput