Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a time dimension, basically dimension is end date of each month. I have a calulation based on end of each month, basically my calculation should be based on end of each month, which is diplayed in x axis of the chart.
say chart
Month Last Date
My calculation COUNT(if A/c Open date >= Month Last Date and A/c Open date<=Month Last Date, ACT ID)
Month last date should be based on each value in the x- axis
Thank you
try liek this..
Count({<[A/c Open date]= '{>=$(MonthEnd(YourDate))}', [A/c Open date] = '{<=$(MonthEnd(YourDate))}'>} [ACT ID] )