Skip to Content
0

How to group on the basis of a condition?

Feb 15, 2017 at 08:17 AM

21

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Feb 15, 2017 at 09:08 AM
0

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

Ian

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sorry Ian for a delayed reply. It worked out for me and the issue was sorted out

0