Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to see Sum of Rating_Calc
Under sum of actual score , it should be sum(Rating_Calc) means 30 but its coming 20 and 2560.
Table:
Load
Year,
Name,
QuestionGroup,
Rating_Calc,
Sum(Rating_Calc) as "Sum Of Actual Score"
Resident Calc
Group By Year,Name,QuestionGroup,Rating_Calc;
@mnvrma try with distinct keyword
Sum(distinct Rating_Calc) as "Sum Of Actual Score"
No it's not working , it brings same value as column Rating_Calc
@mnvrma please share sample data with expected output
@mnvrma please try the below in the script
Calc:
LOAD
"Year",
Name,
QuestionGroup,
Ques_Calc,
Rating_Calc
FROM [lib://dvSourceDataPath/ICO_Recharges_MI/Test/Test2.xlsx]
(ooxml, embedded labels, table is Sheet1);
Left Join (Calc)
Load
Year,
Name,
QuestionGroup,
Ques_Calc,
Sum(Rating_Calc) as "Sum Of Actual Score"
Resident Calc
Group By Year,Name,QuestionGroup,Ques_Calc;
in UI, you can simply add the measure Sum(Sum of Actual Score) to the dimensions.