I have created a Pivot Table in Excel. Here are the fields:
And here is how it looks:
What I want to do now is create a calculated field called Stock Price. The goal of this field is to list the PRICE value IF the Type is 'Stock'. I.e., PRICE and Type are columns in my data. I want to create a new column called Stock Price and populate that with data ONLY if the Type equals Stock.
I thought I could do using an if formula as follows: IF(type="Stock",PRICE,0)
However, the result is NOT what I expected. This is what I get:
All of the rows have a value of 0, even when the Type equals Stock.
What am I doing wrong?
