Display sales qty only once, instead of summing it up

[akshaym]

Hi @David_Wong,

I was able to get the desired results thank you for helping out. I also found a similar post.

Getting sum subtotals after using min as the level of aggregation

hi, I want to get the subtotals of my data using a pivot table after selecting min as the level of aggregation. However, whenever I do this, the subtotals become 0. For example, on the table below, I want the subtotals for A and B but before I can do that, I need to get rid of the duplicate row that contains Spain so I selected min as the level of aggregation for price (if I choose sum the value for Spain becomes $100 which is wrong). Selecting min however does not let me get the right type of…

Appreciate your help.

Thanks,