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