Pivot Table

[dodokh]

Hello,

I have a report in excel, I need to prepare pivot table for this report, everything goes smoothly and transferred to the pivot table except the amount column, I get all the amounts equal to 1, what is the problem, how can I get the amounts from my report ?

Thank in advance.

 

[Robert Mika]

Right Click on the Pivot table header--> Value Fields Settings-->Sum

Hope it helps