Forum Discussion
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 was originally listed with a "Pipe" separating them, but I did the split column to give me multiple columns.
But as you see RRP can be in Segment 1 and Segment 3. I'd like my chart to sum up all instances of RRP.
RRP occurs 28 times in Segment1 and 11 times in Segment3, but I can't get the pie chart to add all the occurances together.
It just shows 28 in the chart.
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
2 Replies
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,
DaleHi,
In the Split column window, click on Advanced and select rows. Click on OK
Does this help?
