How to hide a row, but not exclude the row data from a sumover calculation

[neelay]

@Akash1 check this link… I think David explained sumover / level aware calculation nicely there…

Level aware sum / sumOver problem

@David_Wong Thanks for the explanation. sum(min(total, [{rule_name}, {event_date}, {channel_id}])) worked on the given example but didn’t work on other data. here is the sample data where it didn’t work, not sure why. Expected output ICD-10 : 93, ICD-9 : 14, FDA Code : 20 total: 127 But, What I got is 86,14,19,119 respectively. [image] The Sample Data can be found here.

Also, check this post. I think David explained sumover solution here.