'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.
And the PivotTable settings is in the Sheet1
THEN I do double-click in the corresponding cell where excel tells me "DOUBLE CLICK"
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.
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
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 1:[1]
once the query is submitted, there's noway to see the original filter.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |