Skip to Content
avatar image
Former Member

How to group on the basis of a condition?

Hi;

My data is as below

Part Num Unit Price Qty Amount

Part1 10 10 100

Part1 12 20 240

Part1 10 10 100

I want the result as

Part Num Unit Price Qty Amount

Part1 10 20 200

Part1 12 20 240

I created the group and I am getting the result as

Part Num Unit Price Qty Amount

Part1 10 40 440

Thanks in advance for the support

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 15, 2017 at 09:08 AM

    Add a second group on Unit price and sum amount in that group. Suppress the PartNum group headers and footers

    Ian

    Add comment
    10|10000 characters needed characters exceeded