Split pivot table? | Dashboards & Charts | Excel Forum

Hi Holly,

It's a bit difficult to picture from your description. In particular this sentence isn't clear "I have a data set with both rows and columns that ideally I would both group". I can't imagine what you mean by grouping rows and columns...do you mean group both rows and columns together, or group rows, and separately group columns? A screenshot or sample file would be helpful, but let me try.

In the Slicer connections list you will see a list of PivotTables, not Pivot Charts. Each Pivot Chart has it's own PivotTable, so if they all share the same cache then you'd see them in the list of Slicer connections.

If you want to group items and have a Slicer for those groups then you need to add a column to your source data for this grouping. e.g. let's say you have a list of produce in a column called 'Produce'. This produce column contains the following items: apples, pears, oranges, potatoes, corn and carrots. You want to group these items into departments; fruit and vegetables and insert a slicer for the departments. So, you add another column to your source data for the 'Department' and the items in that department will be Fruit and Vegetables.

I hope that points you in the right direction. If you're still stuck, please upload a sample Excel file so we can give you a specific solution.

Mynda

Hi Holly,

Thanks for sharing the data. It looks like the data is already partially summarised and pivoted and this is the cause of your problems. Nothing to do with caches.

If you can get the original data you can then use the PivotTable to summarise it. For example, I'd expect to see columns for:

• Category
• Characteristic
• Age Group
• Gender
• Frequency
• Seeker Type
• Membership type (? Family, Senior, Passive)
• Visit Time
• Score

This will allow you to insert Slicers for the Gender, Frequency etc.

Mynda