Hi all,

I am working on a dashboard and I've created a slicer for a pivot which includes a calculated field. This slicer has 7-8 report connections. But when I work on this file and close and re-open, I see that this slicer gets disconnected with other pivots. When I open the file every time I need to go and click on the calculated field's pivot-pivot options-view-show calculated fileds in OLAP. If I don't do this, I get "one or more slicers cannot be connected to the pivottables" error.

Please help me, I did everything and I've almost come to an end. I have to solve this problem.