8 Replies Latest reply on Apr 2, 2019 12:45 PM by shivratan.gupta

    One Filter or Parameter to show multiple measures

    Cristina Palo

      Hey everyone -

       

      I searched to see if there was already a discussion on this but cannot find one that has been answered

       

      Is it possible to create one filter to display multiple measures which are all calculated fields.

       

      Example: I have a parameter with two options Dollars and Units. When I select Dollars, I want the Total Dollars, Dollar %chg and Abs $ chg measures to show on my table....when I select Units - I want the Total Units, Units % chg and U abs chg to show instead.

       

      Can I create this on a calculated field? if so how?

       

      I dont want to bring it into a Dashboard and use double filtering...:(

       

      Thanks in advance for your help!

       

      Cristina