Dimensional Reporting Filter Parent based on Children's Logic

[cognos05]

Hi,

I am stuck with a new requirement.

Customer Hierarchy -      Region- Rep - Customers

Rep will have multiple customers .


Report requirement is to show the reps Sales value for a particular product, if the customer  under the rep had no sales for last 12 month , but had sales now include those customers.


Now I am able to do it with customer level by using 2 filters ,one filter to bring customers that had 0 sales in last 12 months and another outer filter to get the accounts which had sales now.

This works fine, but I dont want to show the customers in my report row , instead I want to show reps.


How would I apply this to rep .

Assume a rep has 3 customers in which 1 customer had o sales for last 12 month and sales in current month, but other 2 doesnt apply , how to show this rep with only one account.

Can I do something like Filter (reps , children() )   . I am stuck at this point.

Please provide your suggestions.


Thanks,
Nithya

[cognos05]

Hi,

Any suggestions on the below issue.

Thanks,
Nithya