“Computer? Tell me how many products account for the top half of all sales?”
The scene in Star Trek IV where Scotty picks up the mouse and tries to instruct the computer by speaking into it was, in my opinion, the lone bright spot in an otherwise lackluster movie. We all feel the same way sometimes of course. We just want to say “hey computer can you just do what I want without making me trick you into doing it?”
(Related: I had a professor once who liked to say “as computer scientists we are trained to communicate with the dumbest things in the world – computers – so you’d think we’d be able to communicate quite well with people.” He also writes a science and politics blog and was one of my favorite professors.)
OK, so how do we build something like this in PowerPivot:
The Handful of Products Shown Account for 50% of All Sales – But How Did I Build This?