Grouping by calculated field

[Farnsbarnes]

Can't seem to find any previous references to this.

In my tabular report one of my fields is a calculated field that outputs text (don't ask... it had to be done this way)!

Each record in this calculated field contains a region (ie Europe, N.America, etc)    My other 'normal' fields cover a range of text and numbers

What I want to do is display the whole table grouped in terms of the regions in the calculated field, rather like having a 'total and aggregation' for the calculated field.

I've tried adding the calculated field in the 'total and aggregation' option, but just get an error when trying to display the table

Any help very welcome.  Thanks!

[Shiro]

I suggest that instead of using a calculated field, create an extra field on your table and use triggered actions to perform the calculation for you. Since it is a normal field, you should be able to group your values from it.

[NiceDuck]

@Shiro

That  will still depends on what is the calculation they are doing. There are chances that their formula is cannot be converted into triggered action. In my experience, TA is not that good on handling decimal values. They automatically round them off.

[Farnsbarnes]

Thanks for the responses.

Unfortunately I don't think I have any alternative to allocating the regions at runtime.  This is because the User has up to 50 different regions which can be selected and countries can overlap.  For example, a User could select 'EU27' or 'Western Europe', or 'Europe', etc.     France, for example, falls into all those regions.  But if the User selects 'Europe', then that's the region I want to assign next to the record with France in the calculated field.  If he selects 'EU27', then it's that region that I want to assign next to the record with France in the calculated field, and so on.

Any other suggestions most welcome!