Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a date field,
I want to pick out the highest value of year from the dates and I want to display the top 10 dates in that year having the highest count for a particular field..
I gave this in the dimension in a straight table,
=IF(DATE(SUBFIELD(RPX_ACTIVATION_DATE,' ',1),'YYYY')='2013',RPX_ACTIVATION_DATE,NULL())
2nd dimension ->RPX_ACTIVATION_DATE
and in the expression,
I gave count(MRP_ID_SDP)..
but, the straight table is not being populated ... the dimension field is null...
How do I get the desired result?
Thanks,
Anju
1) I would create a field using function YEAR(RPX_ACTIVATION_DATE) at script level. Using functions to create a dimention is not a great idea
2) Using "Dimention Limits" you can easily show only 10 highest values
I tried that ....
I want the top 10 count(MRP_ID_SDP) for the latest year ... say 2013 ..... if I give dimension limits ... it sorts year wise
Hi,
You need function: rank.
if you need 10 date max sales
Sample:
You need add dimension: your dimention
next step
Add Calculated Dimension:
=Aggr(if(rank(sum([Sales]),4,1) <= 10,[Your Date],Null()),[ your dimension ],[Your Date])
next step:
Suppress when value is null
next step:
add expression sum(Sales)
Regards,
Yevgeniy
tryc
ount({<YEAR={"=$(=MAX(your_year_field))"}>}MRP_ID_SDP)
Hi!
This did not work for me!
-Anju
this did not work!
-Anju
Can you atach an example?
Hi,
PFA the sample doc.
Regards,
Anju