creating a new column with conditional group by

Question

I am trying to figure a way to sum a column based on conditions are create a new column with the aggregated values.

I need to sum column D based based on column condition from Column A, B and C. Value 1 in column A is the exception. The output that is required is as follows -

Where a new column E is created that sums Column D(2958673+2166646) by the condition of Column A(10,12) and Column B(20) and Column C(3) in Row 1. Similarly, Column D(1799504) by the condition of Column A(12) and Column B(20) and Column C(4) in Row 2

Gordon Linoff · Accepted Answer · 2020-03-13 11:26:56Z

2

This is perhaps a comment, but it is too long.

I simply do not follow the logic that you want to implement. Your results can be produced by a simple query with filtering:

select a, b, c, d as d, d as e
from t
where a = 1;

EDIT:

Perhaps this is what you want?

select 1, b, c,
       sum(d) filter (where a = 1) as d,
       sum(d) filter (where a in (10, 12)) as e
from t
group by b, c;

edited Mar 13, 2020 at 11:26

answered Mar 13, 2020 at 11:21

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

creating a new column with conditional group by

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related