Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Agreed
Yeah, it is truth, I must use set analysis for KPI now, but problem is solved, thank you for warning