Team,
I'm trying to aggregate data that is stored diagonally but having hard time to get it done. As an example, in the attached file, all the cells that are blue in color should be aggregated and return the value in cell B13. Similar for all the other colors.
Appreciate your help. Thank you!!!
Solved! Go to Solution.
Hi @Alt_dp
I was able to reach your layout. I leave up to you how you do the aggregations.
Workflow attached on version 2018.4
Cheers,
Thank You Thableaus!!!