Keep tables from updating

[#1]

Hello again,

I have 3 straight tables (see picture I attached). All three of them show essentially the same stats. The 2nd table I have set to only showing when a selection under Reason Code has been made and the third table only shows when a selection under CPT code has been made.

My question is, how do I get the previous chart to not update its statistics when new selections have been made?

[#2]

Hmm well that works up until I click on a claim ID, then it goes back to displaying 100%, so i tried excluding claim ID and then the % gives me a number I have no idea how it got.

here's that expression:

count([0Reason Code])
/
count({$<[0CPT Code]=,[0Reason Code]=,[CPT Description]=,[Claim ID]=>} TOTAL [0Reason Code])

[pover]

count({$<[Claim ID]=>} [0Reason Code])
/
count({$<[0CPT Code]=,[0Reason Code]=,[CPT Description]=,[Claim ID]=>} TOTAL [0Reason Code])

[#4]

That still changes it to 100% when I click on an item in box 3 (Claim ID).

If there's not a way to change it, it's not a huge deal.