Table Box -not change as selections are made (stay static)

[#1]

Hi

I have a table box and want the information in it to stay static when I make selections.

The 2 columns are  : Team and %

If I select a team , the multi box adapts so that I only have the  % for that team. I would however like this multibox to remain constant so that it always keeps all the teams and %'s in the table. ( I am happy to change to a straight table, pivot etc if that is easier)

Thanks in advance

[#2 · Accepted solution]

You can add set analysis to your formulas if you use a straight table. For example, if your formula is Sum(Sales), use Sum({1} Sales).  Now it will not be affected by your selections.

[#3]

Exactly what I needed!

Thanks