Hello!
I need to calculate the total occurrences of a given measure without ‘counting’ the occurrences, rather by immediately displaying the total occurrences of that number. So far, I have the following expression:
if(match(${subscriptions.count},${subscriptions.count})=offset(match(${subscriptions.count},${subscriptions.count}),-1)
, 1+row()-match(${subscriptions.count},${subscriptions.count})
, 1)
Which returns:
Notice that the ‘New Calculation’ column counts the occurrences sequentially (when 22 is repeated twice, the right column displays 1 occurrence, then 2). I would like for the highest count to be displayed next to the subscription number (left column) but I’m not sure how to go about it. I.e. When 22 is repeated twice, display 2 next to both occurrences.