2 Replies Latest reply: Sep 6, 2011 8:39 AM by Michaël Martel RSS

    Aggr for Two dimensions

      Hi all..



      I would like to display a top in opposite from 2 dimensions.

      In my case, I would like a top 10 (Sales) of Products by Activity of Customer  :it's ok.

      I input these function in used dimensions:


      1 - Activity of Customer

      2 - Product (with formula:


      If(aggr(rank(Sum({<DATELIV={"$(='>=' & date(vStartDate1) & '<=' & date(vEndDate1))"}>}Sales)),Product)<=10,Product)


      and in expression :


      Sum({<DATELIV={"$(='>=' & date(vStartDate1) & '<=' & date(vEndDate1))"}>}Sales)


      My problem, It's to recuperate those data and to put them in other dimension :The country.

      In order : Country/Activity of Customer/Top 10 Products.


      I didn't arrive to input this dimension at the top of used dimension because the filters are applied under the sub dimensions.


      Can you help me?


      Thanks by advance