Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I'm trying to work out if there is a way I can exclude multiple dimensions from a pivot table (so they don't show as a row)
Example Pivot
Installer | Measures |
---|---|
A | 10 |
B | 20 |
C | 40 |
D | 56 |
E | 15 |
F | 12 |
G | 13 |
I want to do something along the lines of
=Installer <> ('C','D','G') so that I am only showing the data for the remaining Installers.
There will be other Tables using these removed Installers, so I can't just filter them out.
Do you know if this is possible, if so how?
thank you
Something like this?
=sum({<Installer-={'C', 'D', 'G'}>}Measures)
Hi. Thanks for this, however I'm not sure its quite what I'm after.
I want to remove the installers from the list completely, what you have suggested seems to leave them in but just give me a 0 value in measures.
I want to show my data like this
Installer | Measures |
---|---|
A | 10 |
B | 20 |
E | 15 |
F | 12 |
So I need to apply the expression you have suggested in here, is this possible?
Ninnart's solution should have worked as it excludes C,D,G from the calculations.
An alternative is to use: =If(Match(Installer,'C','D','G')>0,Null(),Installer) as the dimension expression. Make sure to untick the Include null values option.