Power Pivot filter items are grouped in all but shouldn't

[sza_zsa]

Hi,

I'm having a problem with a (power) pivot table. It automatically adds this all group to all my filters. When I click on all and expand it I get the actually set of filters I want. Only these also have the expand sign (+) next to them but there is nothing underneath. When I click on the expand symbol it the disappearse. I tryed ungrouping the in the row box but it then shows its not a group (you cant click on it). Does anyone know whats happening here and how I can change it?

Thanks!

 

[Matt Allington]

It could be a caching issue but I can’t be sure. Try leaving just one item on rows and then manually refresh the pivot (right clic, refresh). Then add back any other columns.