Hello. I thought distinctcount was now supposed to be included in regular pivot tables in 2013? Is this correct? I thought it didn't work because my numbers were text but I changed the source and refreshed and distinctcount still doesn't appear? Heeeeeeelp mee.....