All articles with 'Pivot Table' Tag
{ 7 Comments }
Selective Sub-totals in Pivot Tables [Quick Tip]
Published on May 2, 2017 in Excel Howtos, Pivot Tables & Charts
![Selective Sub-totals in Pivot Tables [Quick Tip]](https://chandoo.org/wp/wp-content/uploads/2017/05/selective-subtotals-excel-pivots.png)
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 above.
How to show selective sub-totals in Pivot Tables
Continue »{ 12 Comments }
Apply Conditional Formatting using Slicers
Published on May 11, 2016 in Cool Infographics & Data Visualizations, Excel Howtos, hacks, Huis, Pivot Tables & Charts, Posts by Hui

Have you ever wondered about applying different Spreadsheet Formats or Styles to reports which you may be send to different people and so the styling may be different for each recipient?
I haven’t, but in this post I will show how you can add it to your worksheets.
Continue »