Filter a summary

[Marneous]

Hi,

I don't know how can i filter a summary on an impromptu report.
I have created a data which give me a range. I want to take only the 50 first lines.
I use a summary fonction (rang in french) and i can't filter it.

How can i do ?

I'm a french, if there is some french to help me it will be more easy for me to explain my problem.

Thanks !!!

 

[GJParker]

Go to the Filter Tab of the Query Data dialog box and change the Filter Type to Summary, Your summary should now be available.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[DoubleD]

In your data query window, go to the Filter tab.
There is drop down box entitled Filter Type, select Summary and filter on your Rank field.
Also, in your Rank calculation field, you will need to select the check box stating: Calculate before the Summary filter is applied.

Pain is stress leaving the body.

DoubleD

 

[Marneous]

Thanks a lot.

IT WORKS !!!!!!!!


I'm a french.
Sorry for my english

 

[GJParker]

pas de problème, heureux je pourrais aider

i think your english is better than my french.

Gary Parker
MIS Data Analyst
Manchester, England