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 |
All times are GMT +1. The time now is 06:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com