I could truly use your expertise here. I think i have been trying to find a "clear" solution for my issue for the past two months and finally decided to chek out this site to get some help with it.
I am using MS Access to create a summary report that I link to an Excel Management Dashboard. I need to show a ranking for ALL Customers, by Product Group, and Month and it has been giving me fits. So please help. I am a novice access query user and I don't know code that well so I pretty much use the query grid. I do know how to view the SQL code and make slight modifications; however I have not been successful with this.
Table Name (CY Data)
I need to Rank:
Customers Total NetR evenue, by PERIOD(Month) and Product Group (total of all Products in this group)
Customers Total NetR evenue, by PERIOD(Month) and Product
ProductGroup Total Net Revenue and Month
ProductGroup PRODUCT total Revenue and Month
I would be truly grateful to get an expert to help me with this - it is causing me heart palpatations! Truly.