i have bar chat, i want to show monthname wise sales that chart, my dime is month name i want to show only Last year Prev quarter sales(2020 Q3) to current year Prev Quarter sales(2021 Q3).
i have used this expression
count({<Monthname = {">=$(=(num(addmonths(max(Monthname),-17))))<=$(=(num(addmonths(max(Monthname),-1))))"} its working goob but i want to create this dynamic.
when i used this expression problem is any new month coming last year prev Quarter first month bar not visible.
