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 - 6 of 6 Answers


  • 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


  • 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


  • Aug 17th, 2016

Sort: To sort in ascending order or descending order
Filter: It is like a WHERE clause (i.e. filtered records only will display, remaining records are blocked).

  Was this answer useful?  Yes


  • Apr 6th, 2017

Filtering: Filters the data according to the selected parameter.
Sorting: It simply sort the data in ascending or descending order.

  Was this answer useful?  Yes

Vinayak SB

  • Aug 1st, 2017

In order of the data and rank : 1 1; 3 2; 4 3; 5 4; 5 4; 7 6; 9 7

  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