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