kvrogers
asked on
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.
test-Pivot-Table.xlsx
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.
test-Pivot-Table.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome.
ASKER