Hi Experts,

How do i come up with a filter in a pivot table to show the count and sum of Prices separately?

So if i choose COUNT it should show the number of items but if i choose SUM it should show the total price of the items.

I'm using Price in the values field because all items have prices in it.. just need the option to filter between count and sum..

Thank you