cancel
Showing results for 
Search instead for 
Did you mean: 

Report - Drill down

former_member1107312
Participant
0 Kudos

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.                      

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

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

Answers (0)