Suppress one column in table and exclude its value from another column

[NZFei]

Hello,

Can anyone help with below thing for me please?

My real project is very complicated. Image one branch has sold some product, so this branch and its benchmark group have some feagure while another branch in the same benchmark group has not sold that product. When we calculate the average sold product per branch for the benchmark goup, we should use total sold value divided by one branch, rather than two branches, shouldn't we?

Please see attached sample. Thanks a lot!

1) Dimension is Cycle group.

2) Must select a Branch. Then first expression shows the data for that branch and seconde expression shows the data for the Benchmark Group that the selected branch belongs to.

3) When the branch data is null but benchmark Group data is not null, that row cannot be suppressed automatically.

4) What I want is to suppress the rows with null value for Branch and also in the total number for Benchmarg Group, exclude the value for the branch that have been suppressed.

TransID	Branch	Benchmark Group
Total	118.9	123.7
3	7.0	5.6
4	8.5	5.5
5		6.6
6	6.5	7.7
7	4.5	4.4
8		3.3
9	8.5	2.2
10	5.5	8.8
11		9.9
12		4.4
13	4.4	5.8

[NZFei]

The other branch has not and will never sell that product. Just want to count the average for the branches that sells the product. Thanks.

[NZFei]

Sorry. My explaination is a little confusing. Please see the attached sample file. Thanks.