Sum of two expressions; source tables as dimension

[qw_jakub]

Hello,

I need to make a sum of two counts. For example count(System1_id) + count(System2_id) .

This expression works fine. But is there a way to use the source system(table)  as a dimnesion?

For example:

Total  (count(System1_id) + count(System2_id) )  : 1500

System1 (~ count (System1_id)) : 800

System2 (~ count (System2_id)) : 700

Other than in this chart the systems (tables) are completely unrelated. I am trying to avoid concatenation, as this would make me do a lot of changes.

Thanks for any tips.

[swuehl]

Maybe like this:

Use a synthetic dimension using valuelist:

=valuelist('System1','System2')

then as expression

=pick(match(valuelist('System1','System2'), 'System1','System2')

,count(System1_id)

,count(System2_id)

)

and use sum of rows as total mode (in your straight table, forgot to say).