Sum up data from multiple columns

[jsjames2285]

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.

[Ashish_Mathur]

Hi,

In the Split column window, click on Advanced and select rows.  Click on OK

Does this help?

[v-jiascu-msft · Accepted solution]

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