Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a simple pivot table with two dimensions and a sum(value) expression, see screenshot below.
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.
use
FirstSortedValue( aggr(sum(Value),Year,Age), -aggr(Age, Year, Age) )
use
FirstSortedValue( aggr(sum(Value),Year,Age), -aggr(Age, Year, Age) )
Hi,
Have you tried using MAX (Age)?
Hi.
You can also do it the following way:
sum( {$<Age= {$(#=max(Age))}>} Value)
Regards.