Hi All,
I have Year, Month, Quarter fields,
KPI is there, here displaying the Max year value, If select the Quarter it will display the Max month of the quarter values
ex:- If I select 2021, Q1 it will display the Mar value, If I select the 2021 Q4, here Dec data is not there, so it will display the Nov data. If data is not there, it will display the previous month data of quarter.
Thank you.
Ram