Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table calculated field or item
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help Using Calculated Field or Item in Pivot Table | Excel Worksheet Functions | |||
Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Calculated Field/Item in a Pivot | Excel Worksheet Functions | |||
Pivot Table Calculated field item | Excel Discussion (Misc queries) |