Find the sum of latest Cumulate_User for each account in a Monthly Trend line chart
I want to show this in a Monthly Trend line chart where my dimension is "Time_period" which has Month-Year like format Jun-18, May-18 and so on. For reference the Date field to create the dimension "Time_period" is "Ref_date".
So for a particular Month-Year the measure value should include sum of latest "Cumulate_User" for each account against that Month-Year. For example, In Jun-18 the measure value point should be 47 (=28+19), against Jul-18 the measure value point should be 61 (=36+25)and so on for rest of the rest of the Month-Year values. After when a person selects a particular Account from the Filter pane , the value of the measure should shrink down to the latest "Cumulate_User" value against that corresponding account for the particular Month-Year i.e. after the chart is built when I select Account='Private' my Monthly Trend Line chart for Jun-18 should have measure values shrink-ed from 47 to 28 and for Jul-18 and for rest.
Can you please help how to write down the correct Measure expression for the Monthly Trend Line chart as the below expression is not showing the right value when "Time_period" comes into play ??