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!!
Solved! Go to Solution.
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
Solved, thank you!
Solved, thank you!!