i have created one variable as max(Month) . so it works fine . it gives me latest month by default and if some one select month filter also it works fine . but if some one select quarter it always take last month of quarter.
example: in quarter i have , 202105, 202106, 202107 ---- for FY21Q3 it takes only 202107.
requirement is i have one text box in that always it should show latest month volume. example by default i should see aug month volumes. but if some on go to month filter and select any month it should give that respective month results. and if some one select any quarter it should give that quarter results. quarter means it 3 months.