It uses by default the sum function for all numbers and keeps formulas.Therefore the only remaining thing to do is to determine how to group the sheets.You will need to verify that each Dynamics ERP company has been set up in Management Reporter.
In this example, CEU is pulling data from Dynamics AX and CEE is pulling data from Dynamics GP.
For this, you can use one of the merge & combine tools included with our Ultimate Suite for Excel.
Supposing you have a few spreadsheets that contain information about different products, and now you need to merge these sheets into one summary worksheet, like this: With the Copy Sheets added to your ribbon, the 5 simple steps is all it takes to merge the selected sheets into one.
by Dig DB “Use this Excel add-in to remove duplicates.
Remove by list matching or key fields; do Access-like query, aggregation, join; simplify pivot table with a roll-up that outputs in simple list; enhance pivoting and subtotal to aggregate in 21 statistical functions such as median and count of unique values.