8 Replies Latest reply: Feb 20, 2013 6:19 PM by Pamela Patena RSS

    Chart Percents

      Hello,

      I'm  trying to make a chart that work like this:

       

      Let's say I have 3 suppliers that supply  the products of any category.

      I'm making a bar chart where the bars display the percents of product of each category, so far, no problem with this.

       

      sample chart percents.PNG

       

      In my filters, I have the supplier option, my suppliers have a percent of volume  of product (not considering the category).

       

      SupplierPercent of Product
      A50%
      B10%
      C20%
      D20%

       

       

      With this information, if the users selects a Supplier in the filter option (Supplier A),  the chart shouldn't take all the whole product volume as a 100% (which is the most logical process), it should use the 50%, and the sum of the percent of each category should give me the result of 50%.

       

      Any ideas of how to make it work like this?

       

      Thanks