Forum Discussion
Solved
Sum up data from multiple columns
I'm trying to create a pie chart of Segments. The issue is that one "project" can contain multiple segments. But I want to have a chart that sums up all of each type of segment. The Segment cell w...
Hi jsjames2285,
There could be two solutions. Please refer to the demo in the attachment.
1. Unpivot the three columns into one column.
2. Create a new table and a measure.
Best Regards,
Dale
Hi jsjames2285,
There could be two solutions. Please refer to the demo in the attachment.
1. Unpivot the three columns into one column.
2. Create a new table and a measure.
Best Regards,
Dale