# 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???

#### 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

#### newinbo Profile Answers by newinbo Questions by newinbo

• Apr 23rd, 2008

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.

#### anuanu Profile Answers by 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.

:)

#### Ramkumar

• 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).

#### mithun

• Apr 6th, 2017

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

#### 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

Send   Reset