I am trying to figure out a way to group my distinct counts pivot table. It was hard enough to get my pivot to do distinct counts without using a formula, but now it will not allow me to group by Year, Month, and Day. I have a report that connects to a remote database and brings in close to a 200K lines. Writing a formula and creating a new pivot would take too much time and it would get removed everytime I refresh my data. Any help would be greatly appreciated.