PowerPivot Nuggets - Part 11 - Add Values to Rows and Columns

While reviewing the session scores of SQL Server Days I ran into a very nice new feature in PowerPivot v2. You can now add values to rows and columns. This allows you to do some very nice analysis very fast.

I just wanted so know how many sessions scored a 10, and how many scored a 9, .....

By simply dragging the score value to the rows area I got the following results.