pivot table

[#1]

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?

[MK_QSL]

If you provide some data or your sample apps, we can try our best to help you on the same.

[ashwanin]

Your requirement is possible in QV.

Number of purchases per period= You can get it from date

and Number of customers = count of customer.

[#4]

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.

[#5]

Thank u! But there is some data in my example.... Is it not sufficient for understanding the issue?

[sunilkumarqv]

Create a one more dimesion of Customer is a Dimension go to presentation column Hide that column

[kaushiknsolanki · Accepted solution]

Hi,

     You can use the dimension as below.

     Aggr(Count(Sales_Id),Cusromer)

     and expression as

     Count(Customer)

Regards,

Kaushik Solanki

[ashwanin]

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)

[ashwanin]

Hi,

i have attached qv for this. it is same as you have mentioned earlier.

[#10]

Thank you!

Correct answer is  Aggr(Count(Sales_Id), Cusromer) and  Count( distinct Customer)