Trying to make a pivot table showing per period:
- total number of customers with credit purchases representing 0-20% of sales.
- total number of customers with credit purchases representing 21-40% of sales.
- total number of customers with credit purchases representing 41%+ of sales.
- total number of customers with credit purchases
Data:
Customer Name, Purchase Period, Purchase Type, Purchase QTY
Simpson, 202211,Cash,1
Simpson, 202211,Credit,5
Simpson, 202211,Credit,8
Simpson,202210,Cash,4
Simpson,202210,Credit,6
Casper Systems, 202211,Cash,6
Casper Systems, 202211,Credit,11
Casper Systems,202210,Cash,8
Lincoln Financial,202210,Credit,6
Lincoln Financial,202210,Credit,9
Lincoln Financial,202209,Credit,6
S6, 202210,Credit,3
S6,202210,Cash,2
S6,202209,Credit,17
Current Measure:
Count(Distinct
Aggr(
Sum({<[Purchase Type]={'Credit'}>}[Purchase QTY])/Sum({<[Purchase Type]={'Credit','Cash'}>}[Purchase QTY])<0.20
,[Customer Name]))
