have a table for Sales
|Customer||Sale_ID||Date Sum and so on|
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|
Is it possible to make this table using nly dashboard?
Solved! Go to Solution.
Number of purchases per period:
Customer is a Dimension,
Number of purchases is An Expression (count(Sale_Id))
After it, to get Number of customers, I need a table, where
Number of purchases is an Dimension,
Customer is an Expression (count(Customer)).
Thus Dimension becomes an Expression. That is a problem.
If you want to create the Pivot like the same as you have attached in the pic
then in dimension use Aggr(Count(Sale_ID),Customer) You can level the same as you required in Heading in Lebel
while in Expression use Count (Customer)