Summarize Data - TRICKY

[Anonymous]

Hi Experts

I am trying to summarize the data as shown in the image, cannot get the correct results...need the ID column to still be part of the calculation - i fthat makes any sense.

[jdbuchanan71 · Accepted solution]

@Anonymous 

I must be missing something in your request.  If you just pull the File and Value fields into a table and set the file to Don't Summarize and the Value to Sum isn't that what you are looking for?

[Anonymous]

thanks for the feedback i wasn't thinking straight.