Sorting Input Schedule

[Former Member]

I would like to sorting the input schedule by Customer Description + Product ID.

We need to see all customer together even if the ID Customer is diferent.

But when I select to sorting in Edit Report the data is messy. Example:

Customer desc.      Customer ID     Product          Account          Value

Ambev                    100001               58956ab        Volume          10

Ambev                    100578               15898ce         Volume            20

Ambev                    100578                15898ce        Price                 10

Ambev                    100578               15898ce        Total Price     200  

Ambev                    100001                58956ab        Price            1.000                                   

Ambev                    100001               58956ab          Total Price     10.000

Any idea how I can organize the input as bellow?

Customer desc.     Customer ID     Product     Account     Value

Ambev                    100001          58956ab     Volume       10 

Ambev                    100001          58956ab     Price               1.000

Ambev                    100001          58956ab    Total Price     10.000  
Ambev                    100578          15898ce     Volume          20

Ambev                    100578          15898ce     Price               10

Ambev                    100578          15898ce   Total Price     200

Thank you

[former_member186338 · Accepted solution]

Sorry, but how do you want to sort by member description and by ID? Member sorting and grouping is very limited...

Vadim

[Former Member · Accepted solution]

I would like to order by Customer Description and Product ID to keep the data grouping.

[former_member186338 · Accepted solution]

It's impossible!

[former_member186338 · Accepted solution]

Theoretically you can add some property, copy description to this property and use group by by this property... But not sure you will get what you want

P.S. No, you will not get the required result!

Try something like: