Count Years Subscriber

Good Morning,

I am attempting to display how many years our season ticket holders have been a season ticket holder, and was hoping to get some clarification on "Count Years Subscriber"

1. Using a pivot table:

  • Filter by:
    • List
    • Package Season = Broadway
  • Rows
    • Package Season
  • Values
    • # Unique CID
  • Columns
    • Count Years Subscriber (excludes zero)

My report goes back 13 years.  I need some assistance deciphering the results:

  • One question is why don't I get the same numbers in all seasons in year 13, shouldn't it be the same?

Any assistance would be most appreciated.  Maybe there is a better way to go about this?

Thanks,

Kimberly

Parents Reply Children
No Data