I've got a pivot table with several expressions. Each expression is saved in a variable so I can use $(vExpressionVariable1) syntax in the pivot table to get the result.
I've also got two expressions that are currently dependent on each other as I'm using syntax something like:
[ExpressionName2] + $(vExpressionVariable1)
[ExpressionName1] + $(vExpressionVariable1)
There is no problem to use them together in one pivot table. The result is as expected. But my goal is to use them independently in the QV app. Let's say if I just want to display only [ExpressionName1] in the table. Please check the QVW I've attached for better view.
Yes this is what I tried already. But there is a specific case which doesn't allow me to do that. See the file (qvw) attached. The problem is that one expression is being calculated based on the second expressions result and vise versa. That's the reason why I've currently got them in one pivot table.