Unable to get values from two out of three reports when selecting through a slicer
Orlando Yaguas
1
Reputation point
I arranged a pivot table with a slicer to view 3 individual reports. It works fine, but some values need to be corrected in one of the reports. The only way to correct those values is to convert them to formulas using CUBE functions. This conversion only allows you to display the values in one report, but not the values in the other reports when selecting through the slicer. So far it has not been possible to display the values from the other two reports, even though I have tried various ways to deal with this problem. Can anyone help me on how to handle this situation?
Sign in to answer