Hi all,
we have a table containing vendors and revenue.
Is there a way to group vendors? This is an example:
TABLE
========
Vendor Revenue
Smith 100
Blake 200
Johnson 450
Martin 700
Should become:
TABLE
========
Grouped Vendor Revenue
Low 300
High 1150
Low contains Smith and Blake
High cointains Johnson an Martin
Obviously these groups are not defined, we could add or remove vendors in this groups, or cerate new groups.
Thank you.
Gaetano.