Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
can you try using the Dimension Limits tab?
Pivot table doesnot have this tab
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)
Hi Anitha,
Please find attached file for solution.
Regards,
Jagan.
Did not find the attachment
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
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.
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)))