I have a requirement to filter all rows that have a growth % > 0. In the same row, I need a calculation that takes sales with growth% > 0 /total sales (regardless of growth). How can I filter detail, but not in the percentage calculation. I think I need to use either a tabular set or child tabular model - but not sure of the exact steps.
Thanks for the help.
Will sales with growth / total sales be displayed in a separate list?
no - they want it in the same list report as the detail. The sales are grouped by product and customer. So - there might have been growth of a product for one customer but not the other. They only want to show customers that had growth on the list report and have a calculation on the same list report that has total sales for customers that growth/total sales for all customers for that product.
Did u try making the growth% > 0 filter as a summary filter?
I mean did u try changing the Application property of the growth % > 0 filter to After Aggregation.
Regards,
Sri