Search code examples
excelpivot-tablessascube

Analysis Services: How to show the original parameters of Pivot Table Excel after computing filter?

When connecting to AnalysisService / Cube with Excel, I have a PivotTable in a Excel Tab.

Here it is.

First_Step_Pivot_Table

And the PivotTable settings is in the Sheet1 Excel Sheet

THEN I do double-click in the corresponding cell where excel tells me "DOUBLE CLICK"

enter image description here

What I am trying to say is that I can perform many Pivot Table and filters, and excel creates, for every settings, a NEW TAB after I perform also the Double-click.

Double Click Ok.

But then, how I recall again the original settings for each Excel TAB ?

What is the way to show the originals parameters for every Tab, in Excel, that were used to compute and search or filter some results ?

Maybe there is not a way.

Microsoft® Excel® for Microsoft 365 MSO

Version 2111 Build 16.0.14701.20278) 64-bit

The results in a Excel TAB (Just an example) after doing the double-click to compute the fields putted in the PivotTable

Results

The question is. How, from the results, I can return back to the original settings that originated the table data ? If I don't remember the original parameters that I've put, how I see them again, FOR EVERY TAB ?

If it's not clear, please let me know in the comments Thanks !

Solution

  • once the query is submitted, there's noway to see the original filter.