Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
Create a Straight Table
Dimension
Amount_Type
Expression
SUM({<Amount_Type = {'ZZZ'}>}B) // Using Set Analysis
SUM(IF(Amount_Type = 'ZZZ',B)) // Using IF
SUM(IF(Amount_Type='ZZZ',B))
donot forget to define group by
other way:
load A,
Sum(B),
Amount_Type
resident xyz
group by Amount_Type
where Amount_Type = 'ZZZ'
bu
load A,
if (Amount_Type='ZZZ',Sum(B)) as B
Amount_Type
resident xyz
group by Amount_Type
should do as well
Try this
Temp:
Load A,
B,
Amount_Type
From Table;
Amount:
Load
A,
Sum(B) as B,
Amount_Type
Resident Temp group by Amount_Type;