Nice Pivot, But I Only Want to See Months Where Eight
or More of My Stores Went Negative!
***Update: Technique Extended, Workbook available
In a followup post I have added a slicer that lets the report user control the minimum number of stores required, rather than fixing it at 8 like this post does. Also, the workbook is now available for download.
Find both in the followup post, located here.
Tales from Remote Consulting
Awhile back I left my job to start a new company. I’m not yet ready to announce what that new company is about – I’m working hard on that and you folks will be the first to know. Spoiler: it’s about PowerPivot and Excel.
But in addition to hard work, there’s also a lot of waiting involved in all of that. I’ve been filling the gaps with training and remote consulting to keep my head in the PowerPivot game.
Remote consulting in particular is a lot of fun – people send me a workbook, I spend 1-3 hours and build what they want, then send it back. Gives me a good sampling of the problems that are “out there.”
One of those remote consulting jobs featured the problem pictured above (except that they had real data, and what I’m showing is 100% fake).
How Many Stores Fell Below Zero Each Month?