Category: Design, Usability, and Appearance

Dynamic TopN Reports via Slicers, Part 2

OK, picking up from Tuesday’s post, with the goal of explaining the techniques. And remember, you can download the workbook here! Two Disconnected Slicers Ah, another favorite technique.  Slicer tables […]

Written by on July 5, 2012

KPI’s in PowerPivot V2

On Tuesday, in my intro to David Hager’s post, I promised to circle back “later today” and add some follow-on thoughts. Well, ONE of those words ended up being truthful

Written by on May 31, 2012

Auto-Modify Every Pivot in a Workbook

It’s been awhile since I’ve talked about Macros (also known as VBA).  I think it’s overdue. Macros are nothing short of amazing.  We couldn’t live without them at Pivotstream

Written by on March 6, 2012

  • 1
  • 2