Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.