Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
have a table for Sales
| Customer | Sale_ID | Date Sum and so on |
|---|---|---|
| A | 1 | ... |
| B | 2 | ... |
| C | 3 | ... |
| A | 4 | ... |
| A | 5 | ... |
I want to make a pivot table like this
| Number of purchases per peiod | Number of customers that have this Number of purchases per peiod |
|---|---|
| 1 | 2 |
| 3 | 1 |
Is it possible to make this table using nly dashboard?
Thank you, its the same whith what Kaushik.solanki has suggested ![]()