Excel PivotTable add Percentage of Total column

[AweEmperorofChickenKilling]

kind of crazy how a video this old can still be this useful

[isaiahmaragalla]

i have been doing it the wrong way. thanks for showing the correct method

[Anikvikram]

Thank you, quite informative and soothing

[krishnabala]

Perfect! This is exactly what I wanted to know! Thank you.

[lauriewoodhead]

Thank you!! Just what I was looking for!

[pablofranciscodelamotatori]

Thanks for sharing this useful PT excel content :-) !

[andyfreeman]

Excellent video. Thank you so much for taking the time to do this

[israelrangel]

Really easy to understand, thank you!

[lardizabalryan]

You can also sort the columns with the "data" tab

[sudukemsn]

She goes so fast! But thank you, just had to pause and rewind a few times

[SanjayVerma-xqmm]

Hi, What if I wanted to calucate % of products in a particular category?

[gfrsaaaar]

Thank you. I understand your way of thinking but I found a problem. If I want to create calculated field which will use data from field created by grabbing like you I cannot do that because they are not possible to choose. How to fix this issue?
..

[christineklein]

What if you have your data split by month in columns and you only want the % of the grand total for the grand total only? When I do the above, it gives a percentage of the column for all columns.

[shivanijosh]

How can I download the excel file which you are using in all this videos?

[tesstanes]

Based on your example, if I put Category, Year (assume not month), Sales ($) and Sales (%) using a report layout (show in tabular form)-> how do I get the Sales (%) to show correctly base on the Year?

[amilamanohara]

Hi how to write a formula to count number of dates between to specific dats ( ex today()-" some Field in a pivot table)

[larry]

when i save the spreadsheet after calculating the field and reopen, the calculated field shows n/a error message. How do i fix this to ensure the calculated field remains valid.

[sandyshum]

How can i show the average sales per category?

[umg]

there is a better way to sort, how will you sort manually if you have 1000 categories?!

[asese]

i need help on a pivot table test. Can i send you a file and see if you can help me? There's two part questions so i am struggling... they kept flanking me on the test but i thought it was correct.

The tasks are:
Show Total Sales by Region and Category (Pivot1)

In an additional column in Pivot1, show % that each category contributes to the region's total sales. (Pivot1)