ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "Cannot Group That Selection" in a Pivot Table. (https://www.excelbanter.com/excel-discussion-misc-queries/54483-cannot-group-selection-pivot-table.html)

les8

"Cannot Group That Selection" in a Pivot Table.
 
Occasionally I get "Cannot Group That Selection" when working with a Pivot
Table. Any idea why?

Thanks,
Les8

Dave Peterson

"Cannot Group That Selection" in a Pivot Table.
 
Usually, it's because one of the values in that field is either text or empty.

I'd start looking there.

les8 wrote:

Occasionally I get "Cannot Group That Selection" when working with a Pivot
Table. Any idea why?

Thanks,
Les8


--

Dave Peterson


All times are GMT +1. The time now is 11:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com