Medians and Excel Pivot Tables

One of the¬†issues with pivot tables in Excel 2010 (and earlier versions) is that it isn’t possible to calculate median using the Value Field Settings. In this post I am going to first extol the virtues of the median (again) and then demonstrate a formula¬†for calculating the median in a cross tabulation. Medians Again? Why […]