What is the difference between Sort and Filter function

E.g i have a column having data as 1, 5, 7, 3, 4, 5, 9

Sorting will sort as 1,3,4,5,5,7,9
What will ranking do???

Questions by nikitababaria

Showing Answers 1 - 3 of 3 Answers

praveen

  • Feb 15th, 2007
 

Hi all,In Report if we use sort it will disply only either asending ordar ordecending order.where as in Filter, it is an condition that limits the amount of data that can displyed in the report.Those records that satisfy the condition only are displyed in the record.Cheers,Praveen

  Was this answer useful?  Yes

Sort means to sort data or value in Ascending or Descending order. But Filter means to filter any unnecessary data(according to requirement). For example in your case if you sort data by Ascending order it will show up like this..1,3,3,5,...and so on.

But if you filter data to not show greater than 5 your report will not show that data above 5.

  Was this answer useful?  Yes

anuanu

  • May 24th, 2008
 

Hi, it seems u r confused, you have asked the question as diff b/n sort and filter and the given scenario is on sort and ranking.

diff b/n sorting and ranking is : if u apply a sort on a particular object , that object will get sorted according to the order given by you either ascending or descending. where as rank is u cant directly apply a rank on single object , it is u r giving rank to a dimensional  object (eg: ename) based on measure (salary). directly you cant give rank to salary.

Hope it would help U.

:)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions