1 Reply Latest reply on Jan 2, 2014 5:04 PM by Tracy Rodgers

    toggle between total sum and overall total ?

    Bob Anderson

      Hello,

       

      I'm working on a dashboard and I need to display totals in a dashboard so that users can toggle between the totals.

      In the report, the total amount of dollars = Sum(A) + Sum(B) , but I have to create a dashboard such  a way that users have the ability to exclude B or include B.  In other words, if I select checkbox B, it will display Sum (A) + Sum(B) else If I uncheck  B, it will display only total Sum(A).

       

      Any help is appreciated.

       

      Thanks

        • 1. Re: toggle between total sum and overall total ?
          Tracy Rodgers

          Hi Bob,

           

          It depends how the data and your views are set up, but you could potentially just use a single select quick filter if A and B are in the same dimension.

           

          Otherwise, if they are two separate measures, a string parameter could be used--listing out A, B and Both. Then, create a calculated field similar to:

           

          case [Parameter]

          when 'A' then sum(A)

          when 'B' then sum(B)

          when 'Both' then sum(A) + sum(B)

          end

           

          Hope this helps!

           

          -Tracy