Summarize tool

[Srinath_pr_14]

HI,

I have invoice  numbers with more than 1 line items in excel. I want to sum up the total invoice value and the sum should get displayed in each line item of the invoice., 

Criteria should be to summarise the invoice number-supplier wise,

Am using summarize tool with group by supplier name, group by invoice number then sum the value of the invoice. It ain't working, Can someone help?

[Emil_Kos]

Hi,

can you check if your numbers aren’t in the string format?

If this will not help could you kindly advise what isn’t working?

[atcodedog05]

Hi @Srinath_pr_14 

Can you provide some sample data and snapshot of the issue. So that we can look into it.

We will be happy to help 🙂