pivot table calculated field or item

C

craig

Hi, my question is..I want to use an If formula based on the Grp colomn value
BU (see formula below), but it doesnt recognise the value as "BU", it just
returns the false value (value if false).

Pivot table rows are as follows
SO # Grp Cust Whse SO
311450 BQ BAKERS S 10-Nov-Tue
312385 0 MODERN S 12-Nov-Thu
312403 BU BUNNINGS S 12-Nov-Thu

I have inserted a calculated field with formula
=IF(Grp="BU",0,1)
The formula always returns 1
Thanks for your answer
 

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

Pivot table, IF function, calculated item versus calculated field 1
Pivot Table - Calculated Field 2
Pivot Table Calculated Field 0
Calculated Field - vLookup 3
Pivot Table Calculated Field - Sum/count 1
Pivot Table Totals 0
Pivot Table Calculated field error 1
Possible 'calculated field' to total selected pivot table data ite 2

Top