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?



      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.




      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:




      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,