Mercury BI - Run a report, save it as a favorite

Short tutorial on how to run a report, alter it, and then save that altered report as a favorite.

Run the stock 'Purchase Orders' report. Note that it appears as a pivot. The pivot has rows for item number, PO, and Vendor ID. Qty Shipped and Qty Invoiced are in the data area. 

Next, let's alter the report, move the Qty Invoiced up to the top area so that it is no longer in the Data area

This is a little tricky: Hover over QTY Shipped and a little 'filter' icon will appear. Single click on the icon. Filter the Qty Shipped to not start with zero.

 

Below you can see the filter icon, indicating that field is filtered. From the menu across the top, select 'Save Favorite' and fill in the form. 

Now, when you click on 'Purchase Orders' in the report list, you'll see the 'favorite' pop out to the left. You can create an unlimited number of favorites on a report, all pre filtered and sorted, etc. A lot like Smart List, but way better  : )

 

 

 


RealWorldCode gives developers practical, real‑world solutions with clean, working code — no fluff, no theory, just answers.
Links
Home
Knowledge Areas
Sitemap
Contact
Et cetera
Privacy Policy
Terms and Conditions
Cookie Preferences