Merge Row and value in Charts/Straight Table

[#1]

Hi All,

In my Dash board i have a chart and Straight table in that i need to merge two rows and i need to show as single row.

Exampl

ServiceType	volume1	volume2
Inquiry	15522	4522
Service	1271	6354
Other Service	963	123
Unclassified	75	12

need to merge Inquiry and Service as a single column Like "Cases"  and Do the Sum of the two rows.

ServiceType	Volume1	Volume2
Cases	16793	10876
Other Service	963	123
Unclassified	75	12

Cases = Inqiry and Service.

How can i do this...Please help .

[#2]

Hi,

You can get it done by writing condition in dimension.

PFA

Warm Regards

Joshmi

[maxgro]

or yoy can add a calculated field and use it as dimension

load

  *,

  if(match(ServiceType, 'Inquiry', 'Service'), 'Cases', ServiceType) as ServiceTypeGroup;

LOAD * INLINE [

    ServiceType, Vol1, Vol2

    Inquiry, 15522, 4522

    Service, 1271, 6354

    Other Service, 963, 123

    Unclassified, 75, 12

];

[robert_mika]

Hi Joshmi,

Would you mind to share your solution?

I'm using Personal edition.