اكسل

If your pivot tables are part of data model, then you have limited grouping choices. In Excel 365 / 2019, 

• You can group by dates

In all other versions of Excel 

• You cannot group by on any field.

The best option for all versions of Excel is to create additional tables and link them up in the data model to mimic grouping behavior. This can be done easily with the help of Power Query.