pivot table counting
 

Hello, I have a pivot table that counts things on a daily basis. Each day I
refresh the pivot and a new column is added (new days data). The problem is
that I've run out of columns in my spreadsheet as time went on. Is there a
way to customize a pivot table to group columns counts by two days, three
days, a weeks etc..

I could create date groupings in my data source to accomplish this but the
data is queried into the spreadsheet each day and It would be easier if I
could group columns count in a pivot table.
--
Regards,

timmulla

pivot table counting
 

Assuming your dates are actual dates then right click the date field and
select Group and Show Detail. If there are blanks or any values that are not
dates then this will not work.
--
HTH...

Jim Thomlinson


"timmulla" wrote:

Hello, I have a pivot table that counts things on a daily basis. Each day I
refresh the pivot and a new column is added (new days data). The problem is
that I've run out of columns in my spreadsheet as time went on. Is there a
way to customize a pivot table to group columns counts by two days, three
days, a weeks etc..

I could create date groupings in my data source to accomplish this but the
data is queried into the spreadsheet each day and It would be easier if I
could group columns count in a pivot table.
--
Regards,

timmulla