Grouping in the pivot table disorganizes the field list

Question

I am trying to make a custom group in the pivot table that is coming from the Analysis Services Cube (SQL Server 2008R2) in Excel 2010. If I create the group in the pivot table the items in the Pivot Table Field List become disorganized. What I have in the cube are measures that are put in their respective folders that are than visible in the Field List (both folders and measures). But when I create the group the measures and the folders are completely disorganized. Did anybody have a similar issue?

Thanks,

Luka

Answer 1

Any thoughts on this? I found this but of no help since we are already using 2008R2 with the most current patches..

Do I need to open a Connect for this? Anybody???

L

Answer 2

I' using SQL Server 2008 R2 SP1 also and facing the
same problem as described at http://support.microsoft.com/kb/979777/

When the Excel user makes a new custom dimension Group
one folder of measures disappears from the PivotTable field List.

I’ m bypassing the problem by expanding making a new
Hierarchy but I can’t do this every time the problem appears and the KB 979777
does not apply to R2.

Please help.

NK

Answer 3

Microsoft????

Any updates on this for the 2008R2??? People need this and it's a pretty obvious bug!

Thanks,
Luka