11 Replies Latest reply on Sep 18, 2017 4:20 PM by Jennifer VonHagel

    Multiple dimensions to a single filter option

    Anjal S

      I have four standalone reports which uses same view from DB.

       

      I'm trying to calculate the payment analysis based on four categories (0-30),(31-60),(61-90) & Over 90. But I have four different fields (four different reports) which has these four categories in it.

       

      Ex: Consider A(dimension) which has 0-30, 31-60, 61-90 & Over 90

      B(Dimension) which has 0-30, 31-60, 61-90 & Over 90. In the same way for dimension C, and Dimension D.

       

      Instead of developing four different reports for these four dimensions. I'm planning to develop a single report where I could have a filter for A,B,C,D dimensions. Is there any way where I could combine these four dimensions into a single parameter and use this in column field and also add this parameter as a filter. SO, I could select the dimension required from the filter. When I select A it would reflect the payment analysis for the four categories above and the same with the rest of the dimensions.

       

      Thanks in Advance.