Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have a table with fields id, type and sum
id | type | sum |
1 | A | 0.1 |
2 | A | 0.3 |
1 | B | 0.5 |
2 | B | 0.2 |
3 | A | 1.2 |
3 | B | 1.5 |
4 | B | 1 |
so i need to sum values of type B whose also have A type so my result table should look like this:
id | sum only B type |
1 | 0.5 |
2 | 0.2 |
3 | 1.5 |
@AIShatiLove another method is to create a flag in script and use it in set analysis to make expression simpler
Data:
LOAD id,
type,
sum
FROM Table;
Left Join(Data)
LOAD distinct id,
'B' as type,
1 as Flag
Resident Data
where type ='A';
Then use below expression in graph
=sum({<Flag={1}>}Amount)