Hi, i'm new in QV, i have found this questions but i haven't found it, i think it must be simply.
I have a pivot table with two colums that each one contains a formula and i need a third column that for example multiplies the other, how can I reference? I have tried to put (column1 + column2) but it shows in the column the text "column1 + column2" not the value of the operation.
just use that expression name in the third expression.
For example your
1st expression is sum(Sales) and lable is Sales.
2nd expression is sum(Total Sales) and lable is Total_Sales.
3rd expression would be the name of the 1st and 2nd expression i.e. Sales + Total_Sales.
Check the attachment.
Hi Raghu, This was interesting. I never figured this out till now.
I would have mentioned my 3rd expression as '=column(1) + column(2)' and a label explicitly mentioned.