I created a pivot table based on a datasource (SQL server cube).

I then changed the cube to also have a calculated measure.

How do I get the EXISTING pivot table to see the newly added calculated measure? If I create a new data source based on the cube a NEW pivot table will then see it, but I have also lost all the effort I put into the original pivot table.

Any help is appreciated.

Never mind. Data source was looking at wrong server.