Dynamic TopN Reports via Slicers, Part 4 – The Dot Plot PivotChart
After completing the Part 3 extension of Rob’s Dynamic TopN Reports via Slicers, Part 2 post, I did not plan on a forth installment.
After completing the Part 3 extension of Rob’s Dynamic TopN Reports via Slicers, Part 2 post, I did not plan on a forth installment.
Yesterday I left Baltimore BWI airport at 11 am heading back to Cleveland. Like basically all of the East Coast air travelers yesterday afternoon though, I never made it home.
After Rob posted Dynamic TopN Reports Using PowerPivot2!, I downloaded the workbook from the provided link to examine how his “tricks” were done
Someone planted an idea in my head the other day: “hey can we use the Wingdings font in slicers?”
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 […]
A colleague recently pointed me to a blog post on Birst’s website, that says QlikTech has jumped the shark.
Is Your Brain More Valuable Than You Know? ***Update: May 2015 This article is now three years old. I’ve been gone from my last company now for more than two […]
A recent comment/question alerted me to the fact that I’ve never devoted a post just to this very useful (and often misunderstood) function. Time to correct that.
First of all, apologies for being so late. I feel like a total zombie, we got to our house in Ohio 22 hours after we arrived at the airport in Tel Aviv.
Greetings from Israel! I’m over here meeting with Microsoft and my old friend Dany Hoter
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
After a long hiatus, David Hager has returned with a new guest post. He has a clever Excel trick/formula for applying different conditional formatting “acceptable ranges” depending on the context of the current row. In his work, different Tests have different acceptable ranges of values that qualify as Pass/Fail/Warning