Hi Everyone,Thanks for your responses, I appreciate your time.After lot of trials, discussions, I found the solution for this which is as below: --Select the dimension(Internal search term(V30)) and date range on first screen of report builder.--In the next window click on the top 1-10 link of the d...

I appreciate your response but i need only 1 row i.e. top row as shown in the screenshot i have attached. Regards,Harish

Hi Jennifer, I have when i use site metircs it will not show participation metrcis(like revenue particiaption, order participation etc.) I appreciate you response but the above solution is not aligning with my Question. Thanks,Harish

Thanks for the resposne.I need the data for eVar30 dimension only.And there is no dimension as "Date Range" and i won't be getting participation metrics with site metrics dimensions.  

Thanks for the response.I don't require any other rows. i just need the row in the blue box. In report builder, even if you select aggregated below the date range selection , in next step it says the top 1-10 rows of the dimension (i.e. eVar30)There is no option to get the top row only.  

Hi Rajeshwari,I guess you have not seen the attachment i have added in the question.I have 114863 rows for Internal Search Term but i need to overall number in report builder which is highlighted in the blue box of attachment.Thanks.

Hi Jennifer,I guess you have not seen the attachment i have added in the question.I have 114863 rows for Internal Search Term(evar30) but i need to overall number in report builder which is highlighted in the blue box of attachment.Thanks.

Hi Kumararajak,I guess you have not seen the attachment i have added in the question.I have 114863 rows for Internal Search Term but i need to overall number in report builder which is highlighted in the blue box of attachment.Thanks.

I need to get the top row of my dashboard in excel using report builder. How to get it?I am doing this for internal search term.Please see the attached screen shot.

It worked. Thanks a lot yuhusig