Ignore Selection in straight table with Aggr and Maxstring

[BootCam]

Hi ,

I would like to ignore selections when [Field 1], [Field 2], [Field 3], [Field 4], [Field 5], [Field 6] is selected. With below mentioned calculation, it's not working.

=Aggr(
MaxString({<[Field 1]=,[Field 2]=,[Field 3]=,[Field 4]=,[Field 5]=
,[Field 6]=>}[Data Availability Quarter Year]),[Field 5])

Whats wrong in the calculation? Any help is appreciated.

Thanks,

BC

[sunny_talwar · Accepted solution]

Try this

=Only({<[Field 1], [Field 2], [Field 3], [Field 4], [Field 5]
, [Field 6]>} Aggr(
MaxString({<[Field 1], [Field 2], [Field 3], [Field 4], [Field 5]
, [Field 6]>} [Data Availability Quarter Year]),[Field 5]))

[BootCam]

Awesome Sunny! Thanks a lot.

Best,

BC