Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
General Discussions
Discuss any topics that are not product-specific here.
SOLVED
Hello all,
I am attempting to get this data to show the Project Managers name one time - but wanting to combine the Balances into one to show the total cost for each individual, instead of it showing multiple cost lines
Solved! Go to Solution.
Hey @maddoxs
You will want to use a summarize tool to create this aggregation.
Please see a small example using data in similar structure as yours.
The key here is to ensure that the USD column are in a numeric data type to allow you to perform the aggregation.
Hope this helps!
