I cannot create a calculated item in a pivot table - I get message cannot create calculated item on grouped field. This is confusing - I am using example in book pivot table data cruching ch 6 'Creating Dashboard. The two fields are Fiscal period with deata as 200205, 200206, 200207,.... 200402, 200403, 200405; also have revenue field. I am trying to create the item showing current period vs last period using '200404' / '200304' - 1. I cannot even get to the insert calculated item .. because it says cannot use grouped fields, ungroup and try again. What am I missing?
again: Book Pivot table data crunching Ch 6, Performing calculations within pivot table 'case Study Creating a Mini-Dashboard'. I am using data from book!
again: Book Pivot table data crunching Ch 6, Performing calculations within pivot table 'case Study Creating a Mini-Dashboard'. I am using data from book!