Data Analysis with Excel 📈📉📊✅ - Show value and percent in same Pivot Report for extra insight

#pivottables #advancedExcel Let's say you are looking at a pivot report detailing total sales by region. You want to know how much each region's sales are as a percent of total sales too. That is you want both value and percent in the same report? Simple, just add the sales field to values area again and this time use "show value as" feature to display number as % of column total. For example workbook and resources visit: https://chandoo.org/wp/advanced-pivot-tables/