on 10-08-2014 3:45 PM
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.
Hi Gerald,
Here's what you need to do:
1) Insert a Group on the Customer Field
2) Insert a Group on the 'Widget' field
3) Insert a summary on the Amount Field (and fields you wish to summarize) and place it on the Group Footer for this new group
4) Move all the fields to this Group Footer
5) Go to the Section Expert > Select this Group Footer > click the formula button beside Suppress and use this code:
DillDownGroupLevel = 0
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.