UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Calculate Groups, Office 2013    
 
   
billwild
post Nov 18 2019, 04:14 PM
Post#1



Posts: 126
Joined: 4-June 02



I have a spreadsheet that contains over 1,000 rows of medical expenses. I want to be able to have a macro that will group the providers (could be as many as 50 different ones) and then add a row that will show the totals of each of the numerical columns. I have attached a partial spreadsheet as an example.
Attached File(s)
Attached File  medical_example.zip ( 7.74K )Number of downloads: 7
 

--------------------
always learning....<img src="/forums/images/graemlins/laugh.gif" alt="" />
Go to the top of the page
 
 
Start new topic
Replies
MadPiet
post Jan 3 2020, 07:26 PM
Post#2



Posts: 3,550
Joined: 27-February 09



You can do this with DAX... kind of depends on what you're trying to do with the data, though. useful if you're doing data analysis, but otherwise, probably overkill.
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    28th March 2020 - 03:14 AM