This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
I have a Matrix report that shows products across months. We use a modeled account to capture the product units being forecasted. Essentially, the months are columns and the products are rows. I have a dimension called Product Type which has multiple levels below it with a specific part number at the lowest level. When I run the report, it prints a line for each Product Type level and sums the units for the products within that level. Is there a way to run the report without the rollup? I want to just show the lowest level items on the report.
When you include Product Type in the report design area, drag in the specific part numbers at the lowest level only instead of the entire rollup. If there are many Product types that you are trying to pull in, you can hold down the control key to select multiple Product Types or the shift key to select a range.