Show the day of month with max values

[#1]

Hi all,

I have a problem that I cannot solve.. I have a simple pivot with

Month,

Day,

Column A

And i would like to show in the pivot just the day of this particular month where 'Column A' has the max value..in this case I would like to show for August just the day 27

Do you have suggestion how to do it??

I have tried with MAX( AGGR (COUNT(....), Month, Day)))

but I dont have the expected result..

Thx to all

[jagan]

Hi,

Try FirstSortedValue() like this

=FirstSortedValue(Date, -Sum([Column A]))

Hope this helps you.

Regards,

Jagan.

[fdelacal]

IN PROPIERTIES

SORT

YOU CAN ADD SORT BY EXPRESSION ....in day....

THEN CHEK AND ADD (THE EXPRESSION OF COLUMN A) PUT DESCENDING

HOPE THAT HELPS YOU

[israrkhan]

TRY BELOW...

=if(aggr(rank(sum([Column 1])),Day)<=1,[Column 1])

[Gysbert_Wassenaar]

Close. Try if(count(ColumnA)=max(total <Month> aggr(count(ColumnA),Month,Day)),count(ColumnA))