Creating ad-hoc reports
With our knowledge of the PivotTable basics, creating reports is actually quite simple and can be very fun once we get started. It's kind of like opening presents on Christmas morning, you don't really know how cool your report will be until you start playing with the different measures and matching them with different dimensions. An easy report to start with to get an idea of the power of Excel Analysis cubes for Excel is a simple one that uses the Accounts by Category dimension, the Signed Amount – GL Trans measure and the Periodicity dimension as the columns. To accomplish this, we will use what we have learned in earlier sections to create a new data connection or use an existing connection. Once we have made our data connection, we will drag our measures and dimensions into our area section. We can see from the following screenshot how each of these is placed in our areas section to create the report:
The Periodicity dimension is a rather interesting dimension...