Create set based on column items feature in Pivot Tables 2010
I have a pivot table created in 2010 that I would like to use the
'create sets' feature in. However it is not enabled. The three 'sets' features are disabled as are the OLAP tools / What if analysis options on the Pivot Table options ribbon. What am i missing??? Cheers Julie |
Create set based on column items feature in Pivot Tables 2010
Okay, found the problem - for 2010 the sets are only allowable for
OLAP based Pivot Tables. :( On Nov 23, 10:16*am, jigsaw wrote: I have a pivot table created in 2010 that I would like to use the 'create sets' feature in. *However it is not enabled. The three 'sets' features are disabled as are the OLAP tools / What if analysis options on the Pivot Table options ribbon. What am i missing??? Cheers Julie |
All times are GMT +1. The time now is 06:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com