Running Total


I have a calculated field
countif (RxFillTransactionPioneerRxID
, FacilityName = ‘IN’)

I need help creating a running total of this field. How would i do that?

Hi @Marwa - you can create the running sum formula like this (my field ‘SMB orders’ is similar to your countIf you pasted, I am counting the number of orders where Segment=SMB)


Then you can create a visual like this:

Hope this helps!

1 Like