Agile Central: Excel - How to export Defects along with their User Stories

Products

• CA OPS/MVS Event Management & Automation
• CA Agile Central On Premise (Rally)
• CA Agile Central SaaS (Rally)

Issue/Introduction

How can we use the Excel add-in to export only Defects that are connected with User Stories along with their User Stories?

Environment

Release:
Component: ACSAAS

Resolution

The Defect field that holds the User Story reference is: "Requirement". 

If exported as-is , it will export the User Story's Name. 
This is an example of filtering defects that are linked with user stories , then exporting the user stories' names:

<Please see attached file for image>

To export the User Story FormattedID, you can use this query:

<Please see attached file for image>

Additional Information

More information on the Excel Add-in: 
https://help.rallydev.com/import-export-excel-addin

Excel Add-in's installation guide:
https://help.rallydev.com/rally-add-excel-installation-user-guide

Additional Knowledge Articles on the Excel Add-in:
https://support.ca.com/us/product-information/ca-agile-central.html?q=excel&type=ALL