Experts, I have a query that sums based on a month (sums the Max). I also have a field in this query that adds a month to [Date_Append]. I want to sum based on this "add one month" date just as I do for the [Date_Append].
I have uploaded a sample file.
Grateful for your help.
I hope it is clear, any questions are welcome.
Date_Append MaxODCum MaxWCCum SumMax add1Mo SumMaxAddMo:
2016 Sep $80.00 $339.70 $419.70 2016 Oct
(I want to show the sum for Oct
2016 Oct $95.00 $350.50 $445.50 2016 Nov
(I want to show the sum for Nov
2016 Nov $102.20 $470.00 $572.20 2016 Dec
(I want to show the sum for Dec