Forum Discussion

RichardP's avatar
RichardP
Icon for Helper I rankHelper I
8 years ago

Rolling totals, checking dates and matching between tables

Hi everyone,   I have a general question about what the best approach is to solve a problem.   I have two tables:   Usage table UserID Month Page loads 111 April 2018 12 111 June...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi RichardP

“page load total” should sum for that month and the two months previous, right?

For example, for ” UserID=111”, “page load total” should be 12+3.

 

Best Regards

Maggie

RichardP's avatar
RichardP
Icon for Helper I rankHelper I
8 years ago

Hi v-juanli-msft, yes indeed, that's correct