ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Create set based on column items feature in Pivot Tables 2010 (https://www.excelbanter.com/new-users-excel/270716-create-set-based-column-items-feature-pivot-tables-2010-a.html)

jigsaw

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

jigsaw

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