Aggregation & Set Analysis within Variable

[Senor_Dai]

Hi,

I have two Dimensions :

1. User
2. Department
3. AuditTime

and two Flag fields:

1. Flag_Today
2. Flag_Checkout

I have the following variable: 

=Count({<Flag_Checkout={'1'},  Flag_Today={'1'}>}AuditTime) 

Can anyone advise on creating a second variable that shows the highest Count by User .  Eg, vHighestCheckout could show 50 for 'today' 

If I use the following Example Pivot :

Id like a variable that contains '11' 

Many thanks for any help

Dai

[MayilVahanan]

Hi

Try like below

=Max(Aggr(Count({<Flag_Checkout={'1'},  Flag_Today={'1'}>}AuditTime) , User))