1 Reply Latest reply on Nov 22, 2012 3:44 AM by Ranjan Sahoo

    Default group by hindering me of top 10 because of sub-aggregation.

    Ranjan Sahoo

      Hi Team,

       

      In the attached file,sheet number 52, I want top 10 initiative lists based on individual row value rather than sub aggregation at initative level.

       

      In the report top 10 lists are already present, if you select year as 2012 from quick filter then i am getting only 3 initative with 10 rows because of aggregation at initaive level. I want listing based on single row value like the one in 2013.

       

      Can anybody help me?

       

      Thanks,

      Ranjan