Sum Value of max date per ID

[piyush_s11]

Hi

I have an excel file in which Field ID, Object, Department, dept these columns are present. I have taken this file with script editor into QV. (please see screenshot )

I wanted to show sum of actual with the object ID in the chart.

ex: take sum of actual if object ID is chart1, chart2 & chart3.

[mrybalko]

You have data model problem. Fields Object and actual don't have any relation.

To connect tables Categories and KPIS you use composite key FieldID + Dept. And there are no match values combination in both tables

[piyush_s11 · Accepted solution]

Sorry I got the answer.

The answer is 

=sum({<ObjectID={'CHART2','CHART3','CHART1'},Dept={Dept1},[Month] ={"<=$(=GetFieldSelections([Month]))"}>}Actual)