Forum Discussion

KH11NDR's avatar
KH11NDR
Icon for Helper IV rankHelper IV
8 years ago
Solved

Running total, by Project ID column

Hi Guys   I Need the running totals each month in a column for the Days column grouped by Project ID.   Thanks Guys   Project ID Days Date Running Total Days AA 16 01/01/2018 16 ...
Need Help
  • Stachu's avatar
    Stachu
    8 years ago

    they do work for me - is the Table[Date] of data type Date? Other than that I cannot think of other reason for it not to work

Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

they do work for me - is the Table[Date] of data type Date? Other than that I cannot think of other reason for it not to work

KH11NDR's avatar
KH11NDR
Icon for Helper IV rankHelper IV
8 years ago

Stachu

 

I've got it working, I've got a further filter, which divides the data by three, If I filter on it manually and divide your column y 3, I get exactly what I'm looking for.

 

Is there obviously a way to filter on two columns?

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    8 years ago

    I don't get the question.
    in the syntax I posted there is filter on Table[Project ID] & Table[Date], so 2 columns are filtered with AND operator, you can add more columns in the same manner

    • KH11NDR's avatar
      KH11NDR
      Icon for Helper IV rankHelper IV
      8 years ago

      Stachu 

       

      Ignore the last question, I'ts working stop on, thanks.