Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.