In my last blog, I showed you how easy it was to use Power Pivot to produce a Pivot table that pulled in data across two tables, Drinks and Categories (without using a Vlookup). Well, we’re going to carry on ditching the Vlookup by looking at Power Pivot’s equivalent function, called “Related” Remember in our fictitious wine bar (in down town Billingshurst) we were able to find out that we stock most drinks that are from the “Wines” category;- But… Read More

By Alison Box
PowerPivot 18th May 2015