How to combine or summarise a sub-set of data for a table

[burgersurfer]

Hi

I have a set of data that looks like this

Code Description

1000 Training

1001 Tennis

1002 Running

...

1011 Other

28 Fitness

29 Skate

30 Socks

The code is refenced in a sales table, that I want to analyse. But since some of the data is "junk", I want to sum it into one code. So I want to take the sales associated with codes 28, 29 and 30 above, and add that to the 1011 (Other) code when creating the table.

Above is only an sample of the data set.

Any ideas?

[burgersurfer]

Hi JJ,

I solved this problem by creating an inline table with 3 colums:

1, 'Football', 'Other'

2, 'Football', 'Other'

1001, 'Running', 'Running'

1011, 'Other', 'Other'

and gave the 3rd column another name, which I use in my calculations.

Thanks for the lead!