sum by categories

[Anonymous]

Hi,

I have 2 fileds

categ	amount
A - categ1	12
A - categ2	100
A - categ1	123
A - categ3	55
B - categ33	61
B - categ44	88

i need to make totals

- on transactions where categ starts with "A-"

- on transactions where categ starts with "B-"

thanks in advance

[Greg_Williams · Accepted solution]

Possible Solution?

=left(categ,1) as a calculated dimension in the Dimension tab of a straight table or chart?

See the attachment (built with 11.20 sr5)

Hope this Helps.

Greg

[Anonymous]

Thank you Greg!

It made the work ...