I need a report for the last 6 months excluding the current month. How I can achieve this using filter
By default when we apply the filter for the last 6 months then it all also considers the current month. A turnaround is, select for last 7 months and then exclude the current month from the filter popup which will look like below-
