Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 280
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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