A straight Table Problem

[swapniltaz]

Hi QLik experts ,

I have a situation where I want to Display Flow with volume ,  I have flow as A,B, C ,D,E

Problem : I want to introduce a Flow category X in Flow such that X is sum of C+D .

The O/p should be a s Below  , i.e I want X to be displayed with C and D both along with Other Category 

and while doing Total it should not double count , How can i achieve the same ?

Flow	Volume
A	10
B	20
X(C+D)	70			X is Sum of C+D
C	30
D	40
E	50
TOTAL	220

[Brett_Bleess]

You are likely not going to get much help on this one unless you can attach a qvw with what you have already etc...  Be sure your data model is complete as you want it and you include some records as well.  Not sure you are going to get anything otherwise on this one.

Regards,
Brett