Merge heirarchy

[gauthamchilled]

I have three levels as dimension, I want to make it as single column and use it as dimension.

I attached the qvw file. I need to create a straight or pivot table with one column as dimension and other as expression

can anyone help or give suggestions to achieve this way. I don't get idea how to merge the three columns without affecting the hierarchy

Level	Expression
NET PROFIT	sum of all the level2 values(Profit+Profit+core profit)
PROFIT	SUM OF (ABC PROFIT+ DEF PROFIT)
ABC PROFIT	SUM OF ABC PROFIT
DEF PROFIT	sum of DEF PROFIT
FGH PROFIT	sum of fgh PROFIT

[mohamed_ahid]

hello ,

like this?

[Anonymous]

Hi ,

Find the attached qv file and let me know if you need anything

Regards,

Devendar

[Kushal_Chawda]

See the attached

[gauthamchilled]

Thanks Kush, But the expression is complex, if I use to calculate mtd ,qtd and ytd. Can it be simplified?

Because I have to repeat the expression for dynamic selection of qtd, mtd and ytd

[Kushal_Chawda]

You can use the set analysis in your expression to get the mtd ytd values. you can do it in same expression

[gauthamchilled]

Ok.

Is anyway I can handle this in the script instead of valuelist?

[Kushal_Chawda]

Yes , you can do this in script as well

See the attached