Much like a puppeteer, writing a report involves pulling the strings behind the scenes, and animating an expression to the front stage. Tableau 9 brings a bucket load of new features to the already popular reporting tool…. Introducing LEVEL of DETAIL CALCULATIONS…. my favourite new feature in Tableau 9, bringing new tricks for the puppeteer.
In PowerPivot, for this particular ranking level of detail example, you would need to carefully craft the level of detail in a DAX expression, do-able, but unless your Dad is Chris Webb, arguably much more complicated than the Tableau implementation.
Watch level of detail calculations in action here …