#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/
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
FAQs
We curate free YouTube courses, organized by category and language — and make it easy for you to track your learning progress.
Yes. Free courses are embedded YouTube videos.
Currently available in English — with Portuguese, Spanish, French, German, and Italian coming soon.
Check ratings, reviews, duration, and description.
All courses include a certificate of participation.
Yes, an account lets you track progress, earn certificates, and save favorites.
We auto-save your watch position so you can resume on any device.
Use the contact page or email support@yourdomaincoursehive.io
Yes! The courses are suggested by the community itself. At the bottom of the page, you’ll find a form where you can suggest a course.
No. We are a learning hub that organizes and curates YouTube courses. Certificates are for participation, not formal accreditation.
Not directly. Only YouTube courses are featured, but you can suggest new ones through our form.
If the YouTube video includes them, you’ll see subtitles or closed captions.
Yes. Once logged in, your progress is saved in the cloud and accessible from any device.
No. Free certificates are included with every free course.
Please report it using the support form or email so we can update or replace the course.
