question

OrlandoYaguas-8681 avatar image
0 Votes"
OrlandoYaguas-8681 asked MiguelEscobar-3907 edited

Slycer and Cube formulas in Excel 2016

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?

office-excel-itprooffice-scripts-excel-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @OrlandoYaguas-8681,
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?

0 Votes 0 ·

1 Answer

OrlandoYaguas-8681 avatar image
0 Votes"
OrlandoYaguas-8681 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.