Adding Values

[LebogangT]

Hi

I want to add values based on field. I will be using a pivot table. The grand total is not what I need to get from the Excel I made.

[Digvijay_Singh]

If possible can you share sample data and expected output?