Grouping rows by rule

[rjback]

Hi,

I know that BO can group by value, i.e. you can define a group like 'good customers' and have good customers grouped into a single row on the report. However, you can only do this by the customer name, for example.

We would like to group by a defined rule so that we don't have to keep going in to the grouping to change it.

For example, we would like to group by 'customers who are based in London'.

Any ideas? So far we haven't come up with anything.

Cheers,
Richard Back
Software Designer
Richard.Back@iplbath.com

 

[blom0344]

Hello Richard,

Your example is not quite clear to me. Do you want to display something like revenue for a group of ´good´ customers and display the sum in 1 row?

If that is what you want you can use the extended context that BO offers to aggregate the revenue for all customers which are based in certain cities. Of course this is generic, if you just want to see the London figures, you apply a filter on the City column.

You probably should look into the pdf manual where calculations within certain contexts are explained. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[rjback]

Here's an example of what we want to do:

Customer A 1234.22
Customer B 5894.36
Customer C 1111.11
London Customers 10012.66
Total 18252.35

So that we're grouping our Customers D, E and F into the London Customer's row due to the information that they're based in London.
We know that we could group by selecting customers D E and F, but in our problem we need to group by the 'city' attribute.

Cheers,
Rich

 

[blom0344]

Hello Rich,

The closest I come to a solution is to put a value based break on the dimension city where I select the value London.
If you then use the sum function it will give a subtotal for the London based customers, but it will still show also the individual customer data in the table.

Perhaps you could split the the query into two seperate queries or split the data in the report into two tables, one for the none London ones and a aggregated table (use the fold option on the table) for the London ones. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com