Hi,
I have designed a list report with the columns: [Product line], [Product type], [Product name],[Quantity].
Tried the below scenarios.
1. Maximum product quantity sold per product line.
This is the summary filter that i have created.
Summary filter: [Quantity] = maximum ([Quantity] for [Product line])
Scope: [Product name]
Output: The report returned required output.
2. Maximum product type quantity sold per product line.
This is the summary filter that i have created.
Summary filter: [Quantity] = maximum ([Quantity] for [Product line])
Scope: [Product type]
Output: No Data Available
3. Maximum product quantity sold per product type.
Summary filter: [Quantity] = maximum ([Quantity] for [Product type])
Scope: [Product name]
Output: The report returned required output.
Am I doing something wrong for scenario-2 which is not returning any data?
Or do we always need to use lowest granularity for "Scope" for the data items in the report?
Thanks in advnce
RK
Is this a Dimensional model? You talk of scope.
Quote from: ranalytics on 16 Oct 2017 11:03:22 AM
Hi,
I have designed a list report with the columns: [Product line], [Product type], [Product name],[Quantity].
Tried the below scenarios.
1. Maximum product quantity sold per product line.
This is the summary filter that i have created.
Summary filter: [Quantity] = maximum ([Quantity] for [Product line])
Scope: [Product name]
Output: The report returned required output.
2. Maximum product type quantity sold per product line.
This is the summary filter that i have created.
Summary filter: [Quantity] = maximum ([Quantity] for [Product line])
Scope: [Product type]
Output: No Data Available
3. Maximum product quantity sold per product type.
Summary filter: [Quantity] = maximum ([Quantity] for [Product type])
Scope: [Product name]
Output: The report returned required output.
Am I doing something wrong for scenario-2 which is not returning any data?
Or do we always need to use lowest granularity for "Scope" for the data items in the report?
Thanks in advnce
RK
Wouldn't the scope of the second summary filter be Product name?
MF.
It is relational model. The scope is specified at summary filter level to find the maximum product quantity sold per product line.
Regards
RK
Summary filters are designed to allow you to filter out grouped items from a report based on summary totals
eg if you had a list report with Product Line, Product Type, Product and Revenue as columns, and you applied grouping on Product Line and Product Type, and totalled Revenue, you could define the following summary filters
[Revenue] > 500,000 with a Scope of Product Line. This would filter out any Product Line groups whose Revenue total was 500,000 or less.
[Revenue] < 50,000 with a Scope of Product Type. This would filter out any Product Type groups whose Revenue total was 50,000 or more.
I'm thinking you're using the wrong sort of filter here? Wouldn't you use a Detail filter with an After Auto Aggregation timing?
MF.
Thanks for your response and explanation on the summary filter.
I figured out the issue. I have left Rollup aggregation function as "Automatic", which was taking Sum. The report has worked fine now after I set it as "Maximum".
Finally, I managed to pull the data for " Maximum product type quantity sold in a product line" with these fields in the report: List Report: [Product line], [Product type], [Product name],[Quantity].
Regards
RK