Rolling 12 month sum for a summarized table

[murphm6]

Hi all,

Can anyone assist me in creating a calculated column that is a running total of volume? I have two tables

- Receipt Table (Original table)

- RawPVM table (summarized the receipt table to get unique combinations of product codes and month/year

I summed the volume from the receipt table in a calculated column in the RawPVM table. I would like to calculate a running total of this aggregated sum by product code and month/year. Does anyone know how to do this? The values i'm getting aren't matching what i'm expecting to see as the current month is being excluded. For example:

In this example - i would expect the 'Rolling 12 Month Sum' column for 2/1/16 to have a value of 23800

Then 4/1/16 should be 30600, etc..

any ideas?

[Greg_Deckler]

@murphm6 This shows how to create a running total:

And this one shows a rolling average, just replace AVERAGEX with SUMX:

[murphm6]

Hey Greg, 

That method doesn't consider the product code when doing the running total - i would like to have the running total be for the aggregate sum by code and date, not the total for the whole table