Sum of Attributes

[Anonymous]

Hi all,

I have a problem:

I have attributes EEE and FFF in Column Name and I would like to show two thinks:

1.) I want to show attribute XXX as Sum of EEE and FFF

     This sum is solved by this code: if(Name='EEE' or Name='FFF', 'XXX', Name) as Name

     So I see only XXX, BUT:

2.) I want to show also EEE and FFF attributes as before

So, I would like to show table as below:

Thanks for your answers

[vinieme12]

Dude replicating the facts is unnecessary here, just saying

also it will cause inflated figures when then dimension is not used in things like KPI's

[sunny_talwar]

Agreed

[Anonymous]

Yeah, it is truth, I must use set analysis for KPI now, but problem is solved, thank you for warning