Number of Occurrence

[aarav021]

I just need to find the count of  no of occurrence of the below data A,B,C without showing the calculation at the front end but the calculation should be done only at the expression level. A,B,C are basically the category for the three years that is 2019,2020,2021. Also the Category which appears max times should only be visible for particular customer id.  

[Chanty4u]

Try this 

if(aggr(count({<Year = {'2019', '2020', '2021'}>} Year), CustomerID) = max(aggr(count({<Year = {'2019', '2020', '2021'}>} Year), CustomerID)), 

maxstring({<Year = {'2019', '2020', '2021'}>} Category), ''), 

[Kushal_Chawda]

@aarav021  not quite get what exactly you are looking for. Could you elaborate further?