• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

Summarized report rolled up by GPI14 and MSI

Good Day Experts

Using the items below what is the best way I can provide a summarized report rolled up by GPI 14 and MSI in excel to include:
¿      GPI 14
¿      GPI 14 description
¿      Generic indicator override
¿      FORMULARY TIER
¿      # utliziers
¿      #claims
¿      $ allowed amount
¿      $ member paid
¿      $ plan paid

The report is 114888 lines
Summary-Example.xlsx
0
Beeyen
Asked:
Beeyen
  • 4
1 Solution
 
PatHartmanCommented:
Your column names don't match your spreadsheet.  The only thing that even comes close to correlating is the amount fields.

To create a totals query,
Select all the columns you want to display and/or sum.
Change the query type by clicking on the sigma button.
Access adds "Group By" to the Total line in the query grid.  
Change "Group By" to Sum for the amount fields.

#Utilizers/#Claims -- I can't identify what these are but I can tell you that "Count" counts ONLY the rows in the domain.  Therefore, you will never have more than one Count column so whatever you are counting here probably needs to happen in a different query that you can then join back to the totals query to produce a report or export to excel.
0
 
BeeyenAuthor Commented:
I included an updated to my spreadsheet to match the message in my question. Let me know. Because of the size of the spreadsheet. I will first place it in an 2010 Access db.
Summary-Example.xlsx
0
 
BeeyenAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for Beeyen's comment #a40008032

for the following reason:

I have decide to rephase and take a different direction on this question.
Thanks
0
 
BeeyenAuthor Commented:
Your solution works.  I had to make some adjustments and have decided to take a different direction.  Thanks
0
 
BeeyenAuthor Commented:
Thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now