pivot table counting


T

timmulla

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.
 
Ad

Advertisements

J

Jim Thomlinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top