title: Distinct Count in Pivot in Excel 2010
body: <p>There is a feature of "Distinct Count" in 2013 excel pivot, but thrs no such option in 2010 excel...is thr any alternative? pl help...I want distinct count of names with country pulled to rows and quaretr pulled to columns in the pivot, given below is an example<a href="https://i.stack.imgur.com/QdMlc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QdMlc.png" alt="enter image description here"></a></p>
  
  <p>Result should be Distinct count of Names for India for Q1 is 2 (2 times Rajesh and Ramesh once)</p>