Limit Columns in a Pivot Sheet
I am looking to use Pivot to create an updating table that will give me a source to use for a trend line graph for admissions over the last 15 days.
My only problem is that I don't know how to stop Pivot from adding columns as the trend gets longer. It may be that Pivot is the wrong tool for the job.
Here's what I've planned so far:
Step 1: Source sheet with a date column for admissions
Step 2: Helper column that measures how long ago admission date was (TODAY()-[Admission Date]@row)
Step 3 (Here's the problem): I would like to Pivot on the source sheet as follows-
Columns- Days ago (but only up to 15 to have a 15 day trend)
Value- Days Ago-Count
My goal is something like this, going out to 15 days:
From my testing, when I get to day 16, Pivot just adds another column.
The only alternative that I've been able to come up with is to build a second sheet, write COUNTIFS formulas for every office, and chart from that. The limitation to this is that it must be manually updated if we add a new office.
Thanks for any help.