Discovered an interesting aspect of an Excel pivot table directly attached Stratum. When looking at data filtered by a dimension that is not included in the category (measure group) that contains the data (which would be Inventory Units in the example previously in this post) and showing rows of data that contain a dimension that is in the category containing the measure (Inventory) Excel will show the data, and does not take the filter for the dimension data that is not part of the category into account. So no special calc needed. This is cool in the case described here, but could cause someone to see data at a level they should not be when they don’t understand that the filter they’ve applied is not being applied to one of the measures they are looking at.
