This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I arranged a Dynamic Table (DT) with a slicer to see 3 types of reports. It works fine, but it is necessary to correct values in one of the reports. The only way to correct is to convert it into formulas using the OLAP tools. This conversion does not allow to show the values of the other reports. So far it has not been possible, despite that I have tried in several ways to cope with this problem. Can somebody help me about how to solve this problem?
Hi @Orlando Yaguas ,
How did you create the connection for the report in Excel?
Did you mean you want to change the data source values in Excel?
Or you want to create the new connection between slicer and data source?
just a Dynamic Table (DT) in Excel with a slicer with 3 buttons to see 3 types of reports. I have to modify the value in one of the reports. I get OLAP tool to convert or modify one of the values. Ok no problem, but when I press other buttons to see the values of the other two reports they appears blanks. I have tried in several ways to cope with this problem.
Regards
Did you change the Slicer connections? Right click the Slicer- select Report Connections, you can check if the connections are still existed. And you can also check the Relationship for each data.g