Slycer and Cube formulas in Excel 2016

Orlando Yaguas 1 Reputation point
2021-09-12T14:02:08.88+00:00

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 Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,474 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Orlando Yaguas 1 Reputation point
    2021-09-13T11:09:16.673+00:00

    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