Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I have period_name and year,month,week filters in my report. And I have table with historical data also. In that customers are changing from one grade to another grade in over a period , in this we have grade,grade_start_date,grade_end_date, current_grade_flag(y-> active in this grade, n-> not active moved to some other grade) fields.
so my requirement is to capture only count of active customers by grade for selected filter. ex: if i select 'ytd' in period_name filter then show only active customers count by grade. if i select year that year active customers count. can anyone provide me the logic in expression to implement the above requirem.
Thanks in advance.
See this document: IntervalMatch and Slowly Changing Dimensions