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?
Hi,
You can use the dimension as below.
Aggr(Count(Sales_Id),Cusromer)
and expression as
Count(Customer)
Regards,
Kaushik Solanki
If you provide some data or your sample apps, we can try our best to help you on the same.
Your requirement is possible in QV.
Number of purchases per period= You can get it from date
and Number of customers = count of customer.
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.
Thank u! But there is some data in my example.... Is it not sufficient for understanding the issue?
Create a one more dimesion of Customer is a Dimension go to presentation column Hide that column
Hi,
You can use the dimension as below.
Aggr(Count(Sales_Id),Cusromer)
and expression as
Count(Customer)
Regards,
Kaushik Solanki
Hi Anna,
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)
Hi,
i have attached qv for this. it is same as you have mentioned earlier.
Thank you!
Correct answer is Aggr(Count(Sales_Id), Cusromer) and Count( distinct Customer)