All articles with 'Pivot Table' Tag
Recently I had to create a Pivot report from monthly data. But there is a twist. The data is spread across multiple sheets, one for each month. Let me explain how I built the pivot for that scenario.
Continue »Selective Sub-totals in Pivot Tables [Quick Tip]
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 »Apply Conditional Formatting using Slicers
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 »