...
Note that the Spend Analytics data set contains export fields from P-card (PCDO), Disbursement Voucher (DV), Purchase Order Invoices (PREQ), and Credit Memo (CM). UConn Health Data is also included by default for invoices and may be tagged as a data field or filtered out. Relevant Spend fields include Total Spend (spend from all sources), invoice spend (spend from any DV or PREQ sources), and p-card spend. These, and any other data fields, can be found under the drop-down, Data, measures, and can be added to the table as rows by clicking on them. Selecting “pivot” will add them to the table as a column.
EXPORTING LOOKS: Data from a Look can be easily exported by clicking the cog icon on the upper right hand of the screen and navigating to download in the drop down menu.
...