Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one dimension called 'Type' and it has 'E3' and 'not E3' as values. I need to create a filter and it should be like 'E3', 'not E3' and 'All'. when I click 'All' in the filter it will give the data for both 'E3' and 'not E3'
How to create a calculated dimension with 'All' as a third value. Can anyone help me with this?
Thanks in Advance
Hi,
try to create a new table like this with Type as key
NoConcatenate
LOAD * Inline [
Dimension,Type
E3,E3
not E3,not E3
All,E3
All,not E3
];
Hi,
try to create a new table like this with Type as key
NoConcatenate
LOAD * Inline [
Dimension,Type
E3,E3
not E3,not E3
All,E3
All,not E3
];
Thank you,
It's working as expected...