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
Hi,
Any suggestions on the below issue.
Thanks,
Nithya