skip to Main Content

“Drill Across” in PowerPivot – Live Demo

Hyperlinks in a Pivot

“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

PowerPivot Retailer Competitive Overlap Application With Drill Across

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?”

 

image

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:

image

Read the Rest

Cloud PowerPivot: Free Trials for the Public

image

image

Actual Web Browser Screenshots of PowerPivot Sites:
Example of Homepage (top) and Report Page (bottom)

***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.

Want to see (and share) your workbooks on the web?

For a few months now we’ve been running free 30-day free trials where you can:

  1. Upload workbooks to the Pivotstream cloud
  2. Interact with them in the browser
  3. Securely share them with colleagues, even if they don’t have PowerPivot or Excel 2010 installed
Read the Rest