Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
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
@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!!