6 Replies Latest reply: Oct 20, 2011 3:01 PM by Rajiv Choytun RSS

    How to use ranked objects obtained from one table in other charts?

      Hello

       

      The situation is that i obtain the top ranked products in one table and now i want to represent each ranked product figures in other charts and put it in a report.

      Example: I have the top 10 products ranked like the picture below.

       

      table.JPG

       

      Now i want to represent the sales and other figures corresponding to each of the ranked products on other graphs/charts, one chart per ranked product in a report like below:

       

      chart.JPG

       

      Therefore i need to generate 10 graphs (one graph per product per page) like the above in a report.

       

      Can somebody please advice on how this can be done and by which method.

      Thanks in advance,

      Rajiv