need help with filtering detail

[tyody]

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.

[Darek]

Will sales with growth / total sales be displayed in a separate list?

[tyody]

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. 

[sridhar_world]

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