Forum Discussion

tpoltorak's avatar
tpoltorak
Icon for Helper I rankHelper I
5 years ago

Need help with Running Total

I am struggling to understand how to calculate a running total.  I have a columns with customer IDs, week numbers and a number of sessions per week. I would like to calculate a running total of the n...
tpoltorak's avatar
tpoltorak
Icon for Helper I rankHelper I
5 years ago

When you are saying Query1[customer] do you mean customer ID's? Then selecting a max customer ID doesn't make sense in my head. Sorry. 🙂

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

tpoltorak , Yes. I was not sure about the column name. I want that work within the same customer ID

  • tpoltorak's avatar
    tpoltorak
    Icon for Helper I rankHelper I
    5 years ago

    So, wouldn't the line 

    Query1[customerID] =max(Query1[customerID]

    attempt to select the maximum customer ID? 

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      5 years ago

      tpoltorak , If you will use customer ID in visual for running total inside a customer, it will take customer from the context.

      • tpoltorak's avatar
        tpoltorak
        Icon for Helper I rankHelper I
        5 years ago