Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot chart that looks like this where the measure is the UNIQUE customer ID
Sign Up Year | Last purch 1m | Last purch 2-3m | Last purch 4-6m | Last purch 7-12m | |
2016 | 73 | 102 | 101 | 133 | 409 |
2017 | 116 | 188 | 185 | 230 | 719 |
2018 | 98 | 170 | 207 | 277 | 752 |
I want to convert this to % customers by sign up year instead so it should return:
Sign Up Year | Last purch 1m | Last purch 2-3m | Last purch 4-6m | Last purch 7-12m | |
2016 | 17.8% | 24.9% | 24.7% | 32.6% | 100% |
2017 | 16.1% | 26.1% | 25.8% | 32.0% | 100% |
2018 | 13.0% | 22.6% | 27.5% | 36.8% | 100% |
I've tried the statements below and neither work..
count(distinct [CustomerID])/Count({<[sign up year]>} Total distinct [CustomerID])
count(distinct [CustomerID])/aggr (Count (distinct[CustomerID], [sign up year])
Any suggestions would be appreciated!
Try it in this way:
count(distinct [CustomerID]) / Count(Total <[sign up year]> distinct [CustomerID])
- Marcus
Try it in this way:
count(distinct [CustomerID]) / Count(Total <[sign up year]> distinct [CustomerID])
- Marcus
Thank you SOOO much!