2 Replies Latest reply on May 18, 2012 1:14 AM by johnslater

    Turning off a line of data in a table/chart

      Hi

       

      I have a table and chart that shows budget and actuals per month for various costs centres.  I have a multiple filter on the cost centres so I can switch them on and off but I would like to do the same with the budget and actuals (e.g just show the budget or just show the actuals or show both together).  Any ideas?

       

      Thanks

       

      John

        • 1. Re: Turning off a line of data in a table/chart
          Tracy Rodgers

          Hi John,

           

          This can be done by creating a string parameter and using it in a calculated field. For example, the parameter would list:

           

          Actuals

          Budget

           

          Then, the calculation would look similar to the following:

           

          Case [Parameter 1]

          when 'Actuals' then sum([Actuals])

          when 'Budget' then sum([Budget])

          end

           

          Then, place this calculation on the view as your measure field. Right click on the parameter and select Show Parameter Control. Then, the user can toggle between Actual or Budget.

           

          Hope this helps!

           

          -Tracy

          1 of 1 people found this helpful
          • 2. Re: Turning off a line of data in a table/chart

            Hi Tracy

             

            Thanks for the response really helpful and gets me most of the way to a solution.  The only problem I now have is if I want to display Actual and Budget together.  Any ideas?

             

            Thanks

             

            John