I have a chart that displays all these dates(prod_dt) that have a month end flag on them(MonthEnd)
I have a dimension of
=if(WildMatch(TrendGroupDesc,'*Retail CD*') and MonthEnd = 1,plan_desc_nm)
and
Prod_dt
and an expression
sum(mtd_avg_bal_amt)
When there is no selection it prints out all of the Prod_dts when the Monthend Flag = 1. I need to have it so when a prod_dt is selected it prints out the previous 12 prod_dts with the month end flag=1.
