Multiple Alternate states - set analysis for default state chart

[MPkg]

Hello,

I have a problem using alternate state in comparison of elements of fields.

I have table:

Groups

Main1

Main2

and following tables:

Main1	A_1	B_1	C_1
Sub1A	1	2	3
Sub1B	4	5	6

Main2	A_2	B_2	C_2
Sub2A	2	3	4
Sub2B	5	6	7

the formula for calculation is:

let vFormula='if(GetSelectedCount(Main1)=1,A_1*2+B_1*3+C_1*4,0)+if(GetSelectedCount(Main2)=1,A_2*2+B_2*3+C_2*4,0)';

I created two Alternate states: As1 and As2 and applied them to two Filter panes:

First filter pane: Groups;

Second filter pane: ="$(=GetFieldSelections([Groups]))";

When I use a bar chart to show result of the formula and set alternate state to As1 for the chart, the formula works.

       

When I want to compare two groups, I need to set bar chart to default state, and write formula like this:

           

But it does not work.

If I create formula like this:

It works but the bar chart does not show correct value.

If I set formula like this:

It works. But if I set formula like this:

It does not work.

What I need is that when I select one sub field of Groups I get the correct value in chart.

How should I define set analysis and expression so I can get what I need?

Thanks.