I have a filter for month selection in my app and each month has its own data entry.
Eg:-
ID Month Service_Status Payment_Cumulative
1 Jan18 Closed $100
1 Feb18 Open $200
1 Mar18 Closed $300
If I select month as Jan18 and Feb18 in the filter, I want to display the payment in the 'Open' service status KPI only(for the latest status) i.e. 200 at the ID level.
Please find below the data for the query.I have to add a key in the data as well. Now, I want to find the payments for latest service status at key and ID level based on the month selection.
ID Month Service_Status Key Payment_Cumulative
1 Jan18 Closed A $100
1 Feb18 Open B $200
1 Mar18 Closed B $300
2 Jan18 Open C $150
2 Mar18 Open C $400
2 Jun18 Closed C $500
Example:-
If I select Jan18, Feb18 and Mar18 in the month filter
then the
Payments for Closed service status = $100(for ID 1 and latest service status of key A) + $300(ID 1 and latest service status of key B)
Payments for Open service status = $400(for ID 2 and latest service status of key C)
