Exporting the same field multiple times with separate parameters
A common question I hear is 'How do I export the same field multiple times using separate parameters?' For example, maybe you need to an export for a mailing house and need to include total giving for 2006, 2007, and 2008 – each in its own column. This requires including the Summary Information, Total Gift amount field multiple times, each with its' own date range parameter. To accomplish this, try the following:
- On the Output tab of your Export select the Summary Information, Gifts, Total Gift Amount field, set the appropriate criteria, and click OK.
- In the right frame, highlight the name of the export; if this is a new Export highlight 'New Constituent Export'.
- In the left frame, double click the Summary Information, Gifts, Total Gift Amount field and set the appropriate criteria and click OK.
- Notice the second Total Gift Amount field appears in the right frame proceeded by 2. This indicates that you have selected the same field multiple times with unique parameters.
- Repeat the above steps to get the number of times the field is needed. For example, to export Total Gift amount three times, follow the above steps three times.
To learn more about this please read knowledgebase solution
BB3503.