Sum(Sales) with Condition

[rajkumarb]

Hi Experts please Assist

I have two fields sales, Group

Group, Sales

ABC,  10

01       20    

02       30

03       40

04      50   

05      60

Now need to create two more fields

1 Sum(Sales) where Group = (01,02,03,04,05) Except Sales(ABC)

2 Sum(Sales) where Group = (ABC)

So the resulting Tables should look like

       Group, Sales Sum1     sum2

--------------------------------------------------

total                       200      10

-------------------------------------------------

          ABC,  10                   10

          01       20     20         

          02       30     30

          03       40     40

          04      50      50

          05      60     60

[giakoum · Accepted solution]

in the reload script ?

if(Group <> 'ABC', Sales, 0) as SalesNoABC,

if(Group = 'ABC', Sales, 0) as SalesABC

in a chart expression?

Sum({<Group-={"ABC"}>} Sales) for SalesNoABC

Sum({<Group={"ABC"}>} Sales) for SalesABC

[Anonymous]

sum(if(Group<>'ABC', Sales)

sum(if(Group='ABC', Sales)

[#4]

Please find the attached qvw file..

Thanks,

Shekar.

[rajkumarb]

Thanks for the Quick reply It Worked

[rajkumarb]

Thanks Maicheal