Count two different words

[beginner91]

hello all,

how can filter in 2 different groups like:

asd                          12

fgh                           13

qwe                         14

rtz                            15

iam adding asd,fgh in one group and count the numbers 12+13=25

and other group qwe,rtz counted 14+15=29

so i can filter to qwertz and it shows me 25

and asdfgh=29

thank you for your support

[pradosh_thakur]

create another tabkle which maps it

field1    field2

asd        asdfgh

fgh         asdfgh

qwe       qwertz

rtz          qwertz

use filter2 as filter. It will work

[beginner91]

i cant. I have something like:

x        counted number: 12

y        counted number: 13

z        counted number: 15

and want a filter for x and yz

and below i have a table when i filter x or yz

the table shows me the counted numbers. check my excel file.

thank you for your support.

[beginner91]

?

[pradosh_thakur]

Hi

Your requirement is still not clear. You have to give us some proper sample data and out put. It would be easier to help out then. Please add sample data clearly, the one you have provide right now is not helping.

Thanks
Pradosh