How to show data quarter wise??

[sheetal1234]

Hi,
I am facing issue in showing data quarter wise,
problem statement is as below,
If I select May month it should give Apr to May in Q1.

if I select Aug then in Q2 it should show Jul to Aug in Q2 ,but it should not change  Q1 value,
it means I want to freeze previous quarter value and change only selected month quarter value.

Pls help

[MayilVahanan]

Hi

Are you looking something like below

Sum({<Date={"<=$(=Date(Max(Date)))"}, Quarter=, Month=>}KPI)

It will display the Month values upto max date available in that year.