Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

How can i get pivot table to list insurance by order?

I am attaching an excel spreadsheet I am working on and I need the data to show the insurance Name according to Insurance ID order.  So 1,2,3 but it is showing it in order by Insurance name.  The patient name has been removed and only ID# remains.

Test would be ID#  E00001461250 .   It should like insurance as MCRAB, USAA LIFE INS CO, TRICARE FL.  But it is listing in alph z-a.
  • 2
1 Solution
Glenn RayExcel VBA DeveloperCommented:
You can't sort on it in the configuration you currently have.  However, because the ID is a number and it's unique to each insurance provider, you can cheat by placing the insurance Order ID's in the Values section and then sorting there.

1) Move "InsuranceOrderID" to the Values section.  You'll see "Sum of InsuranceOrderID" as a label on top.
2) Right-click on any OrderID value in that column (any with a number) then select "Sort", "Sort Smallest to Largest" on the shortcut menu.
3) Change the label in cell C3 to "Insurance OrderID" (note space).

You may also consider changing the layout to the Classic PivotTable view that is much more compact and would allow the values to be sorted by the OrderID.  I've attached a modified version of your workbook with both examples (yours and this other type).

kvrogersAuthor Commented:
Thanks for prompt response.
Glenn RayExcel VBA DeveloperCommented:
You're welcome.

Featured Post

Independent Software Vendors: 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!

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