Every table in DCI can be exported to Excel, regardless of the user's role! This allows the user to total the units using the sum formula in Excel.
To do so:
5. Open a blank Excel document and click cell A1.
6. Click the Data tab
7. Click "From Text"
8. Locate the exported file and click "Import"
9. On the Text Import Wizard, click Finish.
10. Click OK.
11. You can now use the sum formula to find out the total of the units (see the Excel Help Tutorials in the Videos section).
You can also highlight the entries table and then copy and paste it into a blank Excel document.
Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.
|