You may need to use Custom SSRS report based on fetch or SQL depending on your CRM instance. Native Reports may not be able to do it. Apart from this, you can use Excel template to generate the same using formulas and upload it back and export the same
from any view.
If my response answered your question, please "mark the response as an answer" and also "vote as helpful". Regards, Hari. www.crm2011byhari.blogspot.com