Skip to Content
0
Oct 08, 2014 at 02:45 PM

Report - Drill down

17 Views

Hello,

I have a report that I have it grouped by Customer then when you drill down it will show all parts for that customer (purchases for the month). What I want to do is to have the Summary for the purchase by part

So:

When you click on ABC customer I want to show:

ABC Customer Widget 1 100 $1/Each $100

ABC Customer Widget 3 50 $2/Each $100

ABC Customer Widget 4 1 $5/Each $ 5

and this is what I am getting:

ABC Customer Widget 1 30 $1/Each $ 30

ABC Customer Widget 3 10 $2/Each $ 20

ABC Customer Widget 4 1 $5/Each $ 5

ABC Customer Widget 1 70 $1/Each $70

ABC Customer Widget 3 40 $2/Each $80

Any suggestions? I have tried different Groups but can't find the one I need.