Now, we will look at the object components of the Inventory dashboard. When we click on the white area of our sheet object, we can see that again we have a container object, but this container only contains text and lines and two list boxes, one for the fiscal year and one for the fiscal month. What about the charts? Also, what is that looking like a complicated list box in the right-hand side quadrant?
When we open the properties of the object in the upper-right-hand side corner, the Inventory On Hand Report, we can see that the object is actually a Pivot Table. We have not worked with a Pivot Table object before:
Since this is the first time that we have worked with a Pivot Table, open Properties by right-clicking and choosing Properties in the context menu so that we can see what is unique about a Pivot Table object.
On the Dimensions tab, we can see that we are using three Dimensions:
These correspond to the three columns of text data in the Pivot Table:
On the Expression tab, we have three expressions that correspond with the three columns of numbers in the Inventory On Hand Report Pivot Table:
On the Sort tab, we notice that Product Group, the first on the list, is set to sort by STATE ascending and then Text A-> Z, which means Product Group will first sort at that level by the first measure value and then alphabetically.
The next one is the Presentation tab. There are settings on the Presentation tab that we need to pay attention to in order to understand what the Pivot Table is doing. When we have Product Group highlighted, we can see that we also have the following status:
On the right-hand side, the Subtotals group of radio buttons is used to set the display of totals and subtotals in the Inventory On Hand Report Pivot Table. The Multiline Settings section tells the Pivot Table whether or not to wrap text within the groupings.
On the lower-left-hand side quadrant, we have the Inventory Profile Chart. Its colors are consistent with the other charts on the sheet. Therefore, at first glance, we would think that the orange bars would be Inventory Turns, but they actually represent a count of items. Now, we will examine how this range is created for the two measures represented by the orange-colored and the blue-colored bars.
When we right-click and choose Properties for the Inventory Profile Chart, we see that our dimension is Class Turns. If we close Properties, right-click on the white space to bring up the context menu, and choose New Sheet Object and the object type of List Box. With the selection of Class Turns, we can see that the Class Turns dimension already has the ranges built-in the following screenshot:
There is not much to learn about the Class Turns dimension except that we can create our own lists and then turn around and use them in dimensions. Actually, the only item of interest that shows us something new under Inventory Profile Properties is the formula for Number of Items found on the Expressions tab. The formula is:
Count(Distinct [Item-Branch Key])
This is interesting because it shows us how to create a Count Distinct formula to get the count of unique items in a set.