2 Replies Latest reply: Jan 13, 2012 1:28 PM by Edward Hart RSS

    Multiple Dimension Chart Issue

      Hi,

       

      I am having trouble applying variables across dimensions within a chart.

       

      I have attached an example that has a sample set of data.  Essentially I want to apply a percentage to the count (based on product and range) whilst then showing the result by month and product.

       

      I have tried this within an if statement and using input boxes, however I don't seem to be able to get it to work.

       

       

      I would be grateful for any advise on this.

       

       

      Many thanks

        • Multiple Dimension Chart Issue
          Fernando Suzuki

          Hi,

           

          try using this expression:

          =sum(

                    aggr(

                              if(Product = 'A',

                              if(Range = '6 - 10', (( count(Case) / 100)* $(A Range 6-10)),

                              if(Range = '11 - 20', ((count(Case) / 100)* $(A Range 11 - 20)),

                              if(Range = '21 - 30', ((count(Case) / 100)* $(A Range 21-30)), 0))) , 0)

                              +

                              if (Product = 'B',

                              if(Range = '6 - 10', ((count(Case) / 100)* $(Other 6-10)), 0) ,0)

                    , Range, Product, Month)

          )

           

           

           

          Hope this helps you.

          Regards,
          Fernando