Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group Error in Pivot Tables
Hi
I have an Excel Spreadsheet, where the Pivot Tables are created based on the Data from the Analysis Server 2005. I cannot group more than once on the Same column, the first grouping works, say for example. South Africa Zambia UK Ireland India Singapore I can group South Africa & Zambia to get a group called Africa, but if I try to group UK & Ireland to make Europe it gives me the dreadfull error "Cannot Group that Selection", the same pivot on a Analysis Server 2000 data source is working fine. Any help Regards Laks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables - Field Error | Excel Discussion (Misc queries) | |||
Pivot tables - Group Label on each line | Excel Discussion (Misc queries) | |||
Why aren't dates always available to group in pivot tables? | Charts and Charting in Excel | |||
Group function while using Pivot tables | Excel Worksheet Functions | |||
Pivot Tables: Unable to Group and Show Detail | Excel Discussion (Misc queries) |