“I’m telling you there are monkey-fighting hyperlinks in this Monday-to-Friday pivot!”
(Seriously this is how they cleaned up his line for TV, with “monkey-fighting” and “Monday to Friday”)
***UPDATE: I am no longer working at Pivotstream and do not endorse their services. All links are removed from this article but feel free to look them up if you are interested.
Retailer Competitive Overlap Application – New and Improved Live Demo
Revamped/Simplified “Retailer Competitive Overlap” Application
(Note that the Row Labels Area of the Pivot Contains Hyperlinks!)
Clicking an Item to Get More Detail
The retailer overlap application is one that I’ve covered before, in my post announcing our live PowerPivot demo site, but I’ve recently spent some time improving it based on customer feedback and requests.
Specifically, our retail customers have asked the following: “It’s great that I can see that Retailer X competes with me for our senior citizen customers much more aggressively than we thought, but can I get a list of the actual stores that overlap, with addresses?”
But WHICH Stores? I Want to See the Addresses!
Hyperlinks in a Pivot!?
Let’s zoom in on the row area of the pivot pictured above: