How to operate with columns in a pivot table

[#1]

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.

Thanks

[#2]

Hi,

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.

- Sridhar

[#3]

Ok, i will try it step by step.

Thanks

[amit_shetty78]

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.

Thanks, Amit.

[james · Accepted solution]

Easiest way

=column(1) + column(2)

The key is the ()

[#6]

column(1) + coloumn(2)

paranthesis indicate which column you are trying to refer to.