Help Power Pivot Percentage

[laudrupin9]

Hello,

I’m looking for some help regarding my excel file.

I have one powerpivot table with this information.

GREEN	RED	YELLOW	GREY	TOTAL	DateTime	DisplayName
16	0	7	1	24	01/10/2016	A
21	2	0	1	24	02/10/2016	A
21	2	0	1	24	03/10/2016	A
21	2	0	1	24	04/10/2016	A
21	2	0	1	24	05/10/2016	A

<tbody>
</tbody>

Total column is calculated doing = Green + red + yellow + Grey. The result is always 24, because we have 24 hours by day.

Now I would like to show the percentage of this columns.

For example if I take the first line:

GREEN	RED	YELLOW	GREY	TOTAL	DateTime	DisplayName
66,66	0	29,16	4,16	100	01/10/2016 00:00	A

<tbody>
</tbody>

How I can do that, who can help me?

Thanks in advance.

Best regards.

 

[Matt Allington]

You should unpivot your data so it looks like this

dateTime, Display Name, colour, value

You can use Power Query for this.

Then put colour on a pivot table column and dateTime and display name on rows

measures
total = sum(table[value])

% of line = divide([total],calculate([total],all(table[colour]))

 

[laudrupin9]

You should unpivot your data so it looks like this

dateTime, Display Name, colour, value

You can use Power Query for this.

Then put colour on a pivot table column and dateTime and display name on rows

measures
total = sum(table[value])

% of line = divide([total],calculate([total],all(table[colour]))

Thanks for you help. The topic can be closed