Total saels by MonthYear

[joelle_alhanna]

hello,

I want to get the total sales by Month Year in one Table as shown below. the month year shows will varies depending on sales calculation (will take 3 previous month from year /month selection). how can I calculate the total sales by monthyear? is it feasible?

Day	Month and Year	Net Sales - Selling Price	Total Sales
1	Feb-2019	10.00	518
1	Mar-2019	12.00	513
4	Feb-2019	15.00	518
4	Mar-2019	11.00	513
5	Feb-2019	25.00	518
5	Mar-2019	288.00	513
6	Feb-2019	200.00	518
6	Mar-2019	200.00	513
7	Jan-2019	250.00	252
7	Feb-2019	268.00	518
7	Mar-2019	2.00	513

[sunny_talwar · Accepted solution]

May be try this

Sum(TOTAL <[Month and Year]> Sales)

[joelle_alhanna]

It did not work since it gave me the sum for the 3 monthyear

[sunny_talwar]

---

@joelle_alhanna wrote:

It did not work since it gave me the sum for the 3 monthyear

---

What does that mean? I am not sure I follow

[joelle_alhanna]

Sorry, I was doing something wrong.

the expression works

Thank You 🙂