Sumif Table

SergioWW

Hello,

I would like to create a pivot table conditionally summarizing a column in my raw data. Please examples below:

Raw Data:

Blue	Red	Green	Views
True	True	False	33
True	False	True	4
False	True	True	17
False	False	True	20

Desired output table

Color	True	False
Red	Sum of views if true	Sum of views if false
Blue	Sum of views if true	Sum of views if false
Green	Sum of views if true	Sum of views if false

Any insight would be appreciated.

Thanks!!

Jonathan-Sherman

Hi @SergioWW,

You could do this with a transpose, followed by a crosstab to get the data in the format you are looking for:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200324 - DataTransformation.yxmd