I need to show top 10 records based on the Email Sent Date.
I have given the calculated dimension like this..
=if(Aggr(If(Rank(sum([Email Sent Date])) <= 6,sum([Email Sent Date])), Email_Market,Email_Brand,[Email Subject Line])
,[Email Subject Line])
But it is not fetching the latest(or) last 10 records.
I have attached the updated file below. Try by yourself in searching google, you will gain more knowledge. this will also help you to remember the scenarios in future. Good luck .
Pls find the attached qvw and for the market i selected Italy and Brand i selected as Fiat..Now in the e-mailsent date u can see that it starts from 6/17/2016.. Based on that i need to last 6 records.. i.e. from the names from emailsubjectline should come from 6/17/2016 to 5/5/2016.
Pls let me know if you need anything more
Thanks a lot Nagaraj.. My requirement is almost completed.
Now i have one more problem i.e. i need calculate the average of 6 records and i need to display in as image..
Pls find the attached excel on how i need to calculate the formula.
If the value is >10% means then green color and <10%means red and else yellow color.
If this is done my requirement is completed.Kindly help.