How to make a field to be a constant

[Corres]

CRXI SQL Server

I use a formula @Percentage to calculate percentage of passed tests.

percentage :=(PassedTests/distinctcount({TEST.TS_NAME}))*100;

I have 390 records in TEST. TS_NAME.

I show this in graph percentage of passed tests by date.

It works well for all the period of testing. But If I limit my selection in Record Selection formula to display only for first several days, it gives me only records for these several dates and distinct count of records is displayed only for these chosen records. But I need to use in my formula @Percentage ALWAYS number 390.

How to make my distinctcount({TEST.TS_NAME} to be used in the formula as a constant?

Is there a way of displaying a field as a constant?

Thank you

 

[SusanStoHelit]

Can you make it a top N report instead?

 

[Corres]

Thanks for responding, SusanStoHelit!

What do you mean Top N report? I know what is top N, could you explain me in more detailed. I can't understand.

Thank you.