ExcelBanter - Pivot Table - Group by count

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table - Group by count (https://www.excelbanter.com/excel-discussion-misc-queries/181946-re-pivot-table-group-count.html)

Jim Thomlinson

Pivot Table - Group by count

You need to add that to your source data as a calculation in a new column.
--
HTH...

Jim Thomlinson

"Mike D." wrote:

If I have a pivot table that shows the count of a particular item, is there a
way that I can get it to display any count greater than 1?

All times are GMT +1. The time now is 07:00 PM.