3 Replies Latest reply: May 21, 2013 11:03 AM by Sandro Pividori RSS

    Getting max value for combination of dimensions

    Kourosh Karimi-Ghovanlou

      Hi,

       

      I have a simple pivot table with two dimensions and a sum(value) expression, see screenshot below.

       

      Table.JPG

       

      What I need is another pivot table which has Year as the dimension and the sum(Value) for the highest Age in each Year. So the table should look like:

      Year     Value

      2013     168,366,539

      2012     150,206,177

      2011     195,035,156

      2010     213,980,411

      etc...

       

      Can anyone help?

       

      Thanks.