I have created the below filter;
If(Cost_Code = '3', 'Mechanical Engineering', If(Cost_Code = '4', 'Controls Engineering')) as Engineering_Area
I am trying to combine both '3' and '4' to get the Total as another field in Engineering_Area.
Can anyone please help me how to do this? I have attached the script in the qvd file.
Maybe create a link table like this
LinkTable: LOAD DISTINCT Engineering_Area, Engineering_Area as New_Engineering_Area Resident Project_Cost2 Where Len(Trim(Engineering_Area)) > 0; Concatenate (LinkTable) LOAD DISTINCT Engineering_Area, 'Total' as New_Engineering_Area Resident Project_Cost2 Where Len(Trim(Engineering_Area)) > 0;
and now the New_Engineering_Area will have a new value called 'Total'
Hi @sunny_talwar, I am trying to add Total (Cost_Code = '3' and Cost_Code = '4') to Engineering_Area.
So that my Engineering_Area has three fields; Mechanical Engineering, Controls Engineering, and Total.
@vishsaggi I am trying to make Area as a filter in my report;
When I select Total it should show both values Sum(Cost_Code = 3 + Cost_Code =4)
My Area should have 3 fields I can select = Cost_Code =3, Cost_Code =4, Sum(Cost_Code = 3 + Cost_Code =4)