190 likes | 202 Views
New AUXINFO Awards Cube. The following procedures will allow you to find which awards have been received by a member - OR - which members have received a particular award. The Awards Cube.
E N D
New AUXINFO Awards Cube The following procedures will allow you to find which awards have been received by a member - OR - which members have received a particular award. bplatt@juno.com
The Awards Cube bplatt@juno.com
To determine which awards a member has received, click in the “+” until you drill down to the member. Then right click on the member and left click on “Filter.” bplatt@juno.com
The years in which some award was received are shown. bplatt@juno.com
Scroll down the “tree” and right click on “All Awards” then left click on “Nest Rows” on the pop up box, will give you ... bplatt@juno.com
… a list of the specific awards received by the member. bplatt@juno.com
To remove the Sub Total (Summary) lines, right click on one of the “All Awards.” bplatt@juno.com
On the resulting pop up, left click on “Hide/Show..” …then the Hide/Show menu appears as shown below. Click on the “check mark” box to uncheck so as to not “Show Summaries,” then click on OK. bplatt@juno.com
The result without the “summary” lines bplatt@juno.com
To find the date the award was made, right click on the small rectangle above the year column. Then left click on “Down a Level” on the pop up menu. bplatt@juno.com
The result is the Quarter the award was made. Repeat this three more times... bplatt@juno.com
…and the date is shown. bplatt@juno.com
To determine which members in a unit has received a certain award, start with All Units and click on the “+” until desired unit is reached. Right click on the unit and left click on “Filter” on the pop up. bplatt@juno.com
The result is a list of members who have received an award. bplatt@juno.com
Go to the “tree” and click on “All Awards” Right click on the desired award and left click on “Filter” on the pop up box. Then the members in the selected unit with that award will be shown. bplatt@juno.com
These members received the Auxiliary Achievement Award in the year shown. bplatt@juno.com
To see the dates the award was made, right click on the small rectangle above the year column, then left click on “Down a Level” on the pop up menu. bplatt@juno.com
Repeat that action three more times and the date of the award is displayed. bplatt@juno.com
Additional combinations of members and their awards can be found by similar use of the “Filter” and “Nest” actions. bplatt@juno.com