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.
Reply To: Showing Inventory while filter for a Sales Rep
Home
Forums
Stratum User Stuff
Showing Inventory while filter for a Sales Rep
Reply To: Showing Inventory while filter for a Sales Rep
feel free to call us +630.655.3313 info@silvon.com
Account
Members
-
Active 10 months ago
-
Active 1 year, 1 month ago
-
Active 1 year, 2 months ago
-
Active 1 year, 9 months ago
-
Active 1 year, 11 months ago
Recent Topics
- How can I make more stuff fit across the page?
- Is it possible to limit a user to see only data for a specific Division
- Can I have a dashboard or multiple views come up when I start Stratum?
- Can I control the number of rows and columns initially displayed?
- Any ‘Tricks’ to using my Stratum data in Power BI?