Formula based on row Items in Pivottable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I am looking for a way to use an if statement that bases it self on the rowitems in a pivottable as a calculated field
for instanc

Name SName Value Calculated Fiel
A A1 1 =if(Name=A,Value*100,Value/100
A2
A3
B B1 10
B2 20

Is this possible as I have tried with a normal calculated field and as soon as I refer to a row Item I get a value of

Thank

DJ
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PivotTables - Calculations based on generated summary data 2
Calculated Field in a Pivottable 3
#VALUE! in PivotTable using Calculated Field 2
Difference column in PivotTable 1
PivotTable - Sum and Count 1
PivotTable Row Count 3
Manual calculation of calculated items in multiple pivottables 2
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1

Back
Top