Column wise date range in query report

[NCP]

yes, @Suresh_Thakor,

Please check it.

Column wise month wise date range in query report

I created a month wise query report and it really works. SELECT `tabSales Invoice Item`.`item_code` as `Item:Link/Item:150`, SUM(IF(`tabSales Invoice`.`posting_date` between "2020-04-01" and "2020-04-30", amount, 0)) AS `Apr 20-21::100`, SUM(IF(`tabSales Invoice`.`posting_date` between "2020-05-01" and "2020-05-31", amount, 0)) AS `May 20-21::100`, SUM(IF(`tabSales Invoice`.`posting_date` between "2020-06-01" and "2020-06-30", amount, 0)) AS `June 20-21::100`, SUM(IF(`tabSales Invoice`.`po…

---

Product wise Sales Analytics 2 year comparison custom query report

with sales difference between 2 years | Total Amt. | Diff. Amt. SELECT `tabSales Invoice Item`.`item_code` as `Item:Link/Item:150`, SUM(IF(`tabSales Invoice`.`posting_date` between "2019-04-01" and "2019-04-30", amount, 0)) AS `Apr 19-20::100`, SUM(IF(`tabSales Invoice`.`posting_date` between "2019-05-01" and "2019-05-31", amount, 0)) AS `May 19-20::100`, SUM(IF(`tabSales Invoice`.`posting_date` between "2019-06-01" and "2019-06-30", amount, 0)) AS `June 19-20::100`, SUM(IF(`tabSales Invoice`.…