Running Total

[Marwa]

Hello

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

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

[Jesse]

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!