Grouping in Pivot Table when Add this data to Data Model

[dudewheresmyvba]

Like the title. I was having trouble grouping after checking the box to add data to Data Model (I wanted to use the Distinct Count not regular count), and came on this article and comment that said it wasn't possible to group in your pivot table if this box was checked.

https://superuser.com/questions/484616/cannot-group-that-selection-error-when-creating-pivot-table

.

I would really like to have the best of both worlds so if there is a workaround to be able to group and keep my distinct count that would be peachy.

 

[RoryA]

You need to create the groups in the source data. What kind of grouping are you doing?

 

[dudewheresmyvba]

Grouping together weights to make a weight band. It would be more trouble than its worth to make changes in the source data right now but if there isnt a way to do it on the pivot end I may have to.

 

[RoryA]

You'll have to either do the grouping or the distinct count in the source data. The former is generally far simpler.