Archive of posts filed under the PivotTable category.

Slicer or Data Validation list

Posted by on

This note documents a somewhat creative – and I suspect an unintended – way of using a slicer. A slicer is a control element introduced with Excel 2010. It is a large easy-to-use control to filter the results of one PivotTable or even multiple PivotTables. I like the UI look-and-feel of a Slicer and decided …

Continue reading ‘Slicer or Data Validation list’ »

TM PivotTable Dashboard

Posted by on

A client wanted to visualize a table of data with a dashboard where each chart represented specific information in the table. I had two choices: 1) Develop a client-specific solution and charge the client the entire development cost, or 2) develop a more general solution, market it to a broader customer base and charge the …

Continue reading ‘TM PivotTable Dashboard’ »