Createing Calculated Dimension based on dimension values

[Gowtham]

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

[StarinieriG · Accepted solution]

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
];

[Gowtham]

Thank you,

It's working as expected...