formula in hierarchy

[#1]

Hi,
I use a hierarchy, and have a pivot table and staright table in my application.
the dimensions of this pivot table are 3 fields from the hierarchy
I need to create an expression that checks another expresion, and decides which calculation to make.
this check needs to be done only if Depth>=3, if Depth<3 I need to display the sum of lower level (no matter what the another expression is)

I'm not sure if this can be done @QV, but that's my requirements....

Any thoughts?

Thanks,

Nitza

[#2]

Hello are you aware that you can create variables within QV?

Create your other expression as a variable and then use it against your current expression in a chart.