Create set based on column items feature in Pivot Tables 2010

J

jigsaw

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
 
J

jigsaw

Okay, found the problem - for 2010 the sets are only allowable for
OLAP based Pivot Tables.

:(
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help needed in excel 2010 pivot chart 0
Pivot table put multiple "Values" in one row but I want them in one column. 0
Connection files and pivot tables 0
Using VBA to create charts 1
Slicers and Calculated Items in Pivot Table 2
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Excel 2007 pivot table using analysis services cube as data source 0
Query on Group field in Pivot Table 4

Top