2 Replies Latest reply: Jun 28, 2012 6:55 AM by Ali Razavi RSS

    sales graph relative to total

    gidon david

      Hello

      enclosed is a model  sup123.qvw

      the graph show the sales  of  products by  yearmonth and by supplier

      i want to add another line or point  , to show the total of the sales 

      so we can see the suppliers ver Total

      thanks

      gidon

        • Re: sales graph relative to total

          Hi Gidon

           

          I don't think what you wamt to do is possible without amending your script.

           

          try adding this into your script under the table you have loaded..

          Don't forget to give your original table a name (I have used "Fact" in this script).

           

           

           

          totals:

          Load YearMonth,

                     sum(Sales) as Sales

          resident Fact

          group by YearMonth;

           

           

          Left Join (totals)

          Load YearMonth,

                     'Total Sales' as Supplier

          Resident totals;

           

           

          Concatenate (Fact)

          Load *

          Resident totals;

           

           

          Drop Table totals;

          • Re: sales graph relative to total

            Also to make the graph look nicer remember to check the Log Scale box in the Axis tab of the properties.