| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting in pivot tables based on another column | Excel Discussion (Misc queries) | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Name items in Pivot Tables? | Excel Discussion (Misc queries) | |||
| ticked items on Pivot tables | Excel Discussion (Misc queries) | |||
| There should be a Refresh All feature, enabling all pivot tables . | Excel Worksheet Functions | |||
Linear Mode
