Top 10 Values

[#1]

I need to display the top ten values in a pivot chart based on the highest count.

The expression used is:=IF(date(INC_SUBMIT_DATE) > date($(vSliderDate)),count (DISTINCT INCIDENT_NUMBER))

where vSliderDate is the value that is given as an input from the user.

[#2]

can you try using the Dimension Limits tab?

[#3]

Pivot table doesnot have this tab

[Anonymous]

Something like below,

In dimension,

Aggr(If(Rank(If(date(INC_SUBMIT_DATE) > date($(vSliderDate)),count (DISTINCT INCIDENT_NUMBER)))<=10, DIMENSION), DIMENSION)

Expression should be same as your above script.

PS: There might be a typo error in above script. You can follow below generic logic.

=Aggr(If(Rank(Sum(Expression))<=10,Dimension),Dimension)

[jagan]

Hi Anitha,

Please find attached file for solution.

Regards,

Jagan.

[#6]

Did not find the attachment

[#7]

This is displaying the lowest 10 values not the top... I think its taking the least expression value as the first rank. I need to get the highest count to be the first rank

[jagan]

Hi Anitha,

Please find attached file for solution.

Try like thi

Dimension: =if(aggr(rank(SUM(Sales),4,0), DimensionName)<=3,DimensionName)

Expression: =Sum(MeasureName)

Regards,

Jagan.

[Anonymous]

Strange. Can you only use Rank function with expression and see what kind of rank you are getting? If possible share some sample qvw for fastest resolution.

Rank(If(date(INC_SUBMIT_DATE) > date($(vSliderDate)),count (DISTINCT INCIDENT_NUMBER)))