How can I calculate and display the total occurrences of a count?

Rd123
New Member

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:

0f6f17de-7dc9-45bd-b1f8-d0c1a6c48a93.png

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.

0 0 1,718
0 REPLIES 0
Top Labels in this Space
Top Solution Authors