Recently I was creating a pivot report with multiple items in row labels area. I had to show sub-totals, but only for one of the fields. Something like this:
How to show selective sub-totals in Pivot Tables
First instinct suggests that using Design ribbon > Sub-totals we can tell pivot table how we want the sub-totals.But this is like a master switch. It will turn off or on all sub-totals in the report. What we need is sub-totals only at one level of the report (in this case, sub-totals by department, but not by month).
The answer is simple.
- Click on any month label. This will select all months in the row label area.
- Right click > Field settings (you can also access this from Analyze Ribbon > Field Settings)
- In the “Subtotals & Filters” tab, choose “None”
- You are done.
Happy Pivoting. I am off to a short spin on my cycle before heading to work.
12 Responses to “Sachin Tendulkar ODI Stats – an Excel Info-graphic Poster”
A great tribute to one of the greatest batsmen's in Cricket history.
Thanks Chandoos!
A fantastic poster, Chandoo. I suspect most people would assume it was done in Adobe Illustrator.
Great work!
Daniel Ferry
excelhero.com/blog
[...] Visit his post to download the excel file: Sachin Tendulkar Statistics Excel Infographic Poster [...]
[...] Courtesy: Wikipedia.org >> Chandoo.org [...]
Please update the pingback url to http://www.newsilike.in/sachin-tendulkar-infographics/
Awesome man .....super work
[...] Wikipedia.org >> Chandoo.org ← Previous Next [...]
[...] Kummi in Blog, Dashboard, Excel, Infographic | No Comments Jan252012 Chandoo.org published an infographic poster created in Excel. As a big fan of Tendulkar, I really liked this [...]
[...] Via Tags: europe, football, european league, soccer, sports © 2012 Latest Infographics /* */ [...]
[...] Source [...]
[...] Link [...]
[…] Source […]