0 Replies Latest reply: Oct 13, 2011 4:30 AM by Rajiv Choytun RSS

    looping over expressions obtained in another table for a graph

      hello all,


      am facing a real dillema with the generation of a report where i have to represent a product (obtained from another table through calculations) in a graph through its rank. I want to loop over the rank of the products i obtained from a table.

      I obtained the ranks of the products by highest Inventory Coverage from a straight table as shown below


      straight table.PNG

      Now I need to build a graph for the first 3 products (Rank 1,2,3) displaying the Sales and Inventory coverage.

      A graph like this for each product over the last X months. graph shows rank 1: Iphone 4s


      graph per product.PNG



      I need to generate same graph for the products ranked 2 and 3 also in my report also.

      Please can someone help in how to make this possible.

      The application is attached for your convenience and i ll be grateful if anyone could show me the way to make it possible.


      Thanks in advance,