4 Replies Latest reply: Sep 16, 2014 10:07 AM by shravan goud

# How to sum based on other column data

Hi I have a data like this

A B Amount_Type

1 200 ZZZ

1 300 XXX

1 500 YYY

1 300 ZZZ

I want to sum column B if Amount_Type is ZZZ in straight table.

IF(Amount_Type='ZZZ',Sum(B),) Is this correct??

• ###### Re: How to sum based on other column data

Create a Straight Table

Dimension

Amount_Type

Expression

SUM({<Amount_Type = {'ZZZ'}>}B)             // Using Set Analysis

SUM(IF(Amount_Type = 'ZZZ',B))               // Using IF

• ###### Re: How to sum based on other column data

SUM(IF(Amount_Type='ZZZ',B))

• ###### Re: How to sum based on other column data

donot forget to define group by

other way:

Sum(B),

Amount_Type

resident xyz

group by Amount_Type

where Amount_Type = 'ZZZ'

bu

if (Amount_Type='ZZZ',Sum(B)) as B

Amount_Type

resident xyz

group by Amount_Type

should do as well

• ###### Re: How to sum based on other column data

Try this

Temp:

B,

Amount_Type

From Table;

Amount: