When we work with excel services making pivot tables, we have the option to create filters for our reports. As the table report can change its size because of the data, the filter sometimes move to one side to another and this is not the best thing to work with.
What I made when I faced this behaviour was open report in excel and modified the filter grouped all of them:
Then, I publised it in Share Point and when I opened the report I got the next error: We can’t open the workbook in the browser because it uses the unsuported features: Grouped Slicers. So, excel services doesnt allow as to group shapes.
However, we can use another ‘function’ to make the same behavior we were looking for when we intent to group the filters. The next figure shows the option we can choose. We have to make the same thing for each filter we want them don’t move it when the pivot table changes.
Leave a Reply