ADDING COLUMN TOTAL IN PIVOT TABLE & SHOWING %COL ACROSS

[Changez]

Hi Folks,

This one caught me by surprise, I was asked to add a column total in this file and then show the %share of Column total by each row. I have attached the sample file for reference. Normally, I would have more Attributes to Group this by which does the Grand Total across the columns by itself, but given only one Attribute Column to Group this across, I don't see how this could be done.

Your help would be highly appreciated. Thank you.

 

[chirayu]

Why use a pivot for that? see attachment

 

[Chihiro]

Transform the data. From cross-tab structure to flat table.

I.E. DataType, YrWk & Value.

I used PowerQuery to unpivot data, but killed connection, since I wasn't sure if you had access to it.

See attached.

 

[chirayu]

@Chihiro I thought of using PQ too in the end didnt bother for same reason

 

[Changez]

Thanks Guys, Chihiro got the solution I was looking for.