Grid Table with same dimension in Row and Column

[Adamo]

Hi,

I am using QSB  and my data source looks like this :

Order_id	Client_id	Data_type	Date
1001	2301	Sales_date	01/01/2020
1001	2301	Order_date	01/01/2020
1001	2301	Install_date	01/01/2020
1001	2301	Cancel_date	01/01/2020
1002	2302	Sales_date	01/01/2020
1002	2302	Sales_date	01/01/2020
1003	2303	Order_date	01/01/2020

And I need to produce a graph like the following, that counts the orders ID that match both Dimesions. Row dimension and Column dimension is the same one. But pivot table does not allow to put the same dimension in both rows and columns.

	Sales_date	Order_date	Install_date	Cancel_date
Sales_date	Count (order_id)	Count (order_id)	Count (order_id)	Count (order_id)
Order_date	Count (order_id)	Count (order_id)	Count (order_id)	Count (order_id)
Install_date	Count (order_id)	Count (order_id)	Count (order_id)	Count (order_id)
Cancel_date	Count (order_id)	Count (order_id)	Count (order_id)	Count (order_id)

Thanks in advance for your help!!

[msKarthikeyan]

Hi,

You can add same dimension in pivot table by using columname&''

But i think that doesn't solve your problem.

do u want count of sales_date and order_date in row 2 column 1?

-Karthik 

[Adamo]

@msKarthikeyan Thanks for your answer!!

Yess I need to see that in the table, becuase that solution column&"data_type" only fills values in the diagonal of the table and need to fill all cells with all possible combinations.  How many Order_id do have sales_date and order_date in row2 column1, I mean need to count all possible relations as shown in the table.

Is there something I need change in the script in order to get that kind of table?

Thanks in advance!!