Data of Different Grains: A Followup

In last week's post, I explained how PowerPivot can very easily help you solve the "Budget vs. Actuals" problem or any other problem where you have data sets of different granularities that you want to compare in a single report.

The crux of the problem in my example was that my Budget table only budgeted down to the Month level whereas my Sales table went down to the day level.