search

bezlio / bezlio-gallery

Collection of bezls that you can import and use in your Bezlio account
MIT License
3 stars 0 forks source link

CEO / CFO - Total Revenue By Part - Grid #11

Open aellis opened 7 years ago

aellis commented 7 years ago

The query for this gallery item for Epicor is currently being developed, but we will want to Excel target initially anyway. Here is the description of the data:

• Total Revenue By Part o Variations: Year to date, month to date, today o Just return the total revenue for the given period and part

I believe this one works best as a grid sorted by revenue highest to lowest. Add a selector button to the top of the Bezl for Year / Month / Today to load the correct data. Also ensure there is a refresh button. E-mail a jQuery signal and store a local storage variable for selectedPart for the selected row.

gramang commented 6 years ago

@aellis As requested attached the Total Revenue By Part Query Total.Revenue.By.Part.txt