Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Sorry I got the answer.
The answer is
=sum({<ObjectID={'CHART2','CHART3','CHART1'},Dept={Dept1},[Month] ={"<=$(=GetFieldSelections([Month]))"}>}Actual)
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
Sorry I got the answer.
The answer is
=sum({<ObjectID={'CHART2','CHART3','CHART1'},Dept={Dept1},[Month] ={"<=$(=GetFieldSelections([Month]))"}>}Actual)