Hi a m
You are doing it Right. Just use this calculation when you want to Sum per month strore transit
thanks so much for the help Deepak
I have another question for you. I don't know if I should make another topic for it but here goes
what formula can be used to make a calculated field for the variance of the total of ACTUAL SUM and FORECAST SUM for each month?
I tried ATTR([Actual sum]) - [HR Total] but that only works for each transit but it does not work when it's the totals of the month.