12 Replies Latest reply: Sep 24, 2010 5:35 PM by bryankoch

# Keep tables from updating

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?

• ###### Keep tables from updating

You can use set analysis to ignore filters. So in one table you can put sum({\$<[Reason Code]=,CPT=>} Amount).

Is that what you are looking for?

• ###### Keep tables from updating

I added that as a new expression to all three of the tables to give it a try.

If I make a selection from the first chart, the 2nd one appears. When I click the 2nd, the first chart changes it's numbers to the same as the 2nd selection.

I'm looking for when the 2nd selection is made the first chart does not change its values to apply itself to the filter. When the 3rd selection is made, the 2nd chart does not change its values to apply itself to the filter.

• ###### Keep tables from updating

Each table is going to have a different expression. The first graph should have sum({\$<[2nd Selection]=,[3rd Selection]=>} Amount), the second graph should have sum({\$<[3rd Selection]=>} Amount).

• ###### Keep tables from updating

I added those changes and it's still updating for one reason or another. I went ahead and attached my data so you could have a better look at it.

Edit: My calculated dimension was causing it to ignore that statement.

Seems that did the trick. Thanks again

• ###### Keep tables from updating

Since it's a calculated dimension, try this in the first table:

sum({\$<[0CPT Code]=,[0Reason Code]=,[CPT Description]=>} [0Submit Charge])

• ###### Keep tables from updating

sum({\$<[0CPT Code]& ' - ' & [CPT Description]=,[0Claim ID]=>} [0Submit Charge])

ended up being how I got it to work.

Kind of unfortunate that the % columns update anyways because it's narrowed down to one selection. Not sure what the method is around that.

• ###### Keep tables from updating

For the % in the second table use this formula.

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

• ###### Keep tables from updating

The percentage is still updating for selections, including the 2nd chart.

• ###### Keep tables from updating

I forgot to tell you to remove the "Relative" option and format the number to be percentage.

• ###### Keep tables from updating

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])

• ###### Keep tables from updating

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

• ###### Keep tables from updating

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.