creating matrix view on two different dates on single data set

[joyb]

i have two date columns in my data set one for booking(booking date) and one for enquiry(enquiry date). enquiry date can never be null but booking date can be null. i want to show data in a format as desribed in the above screenshot. Now for each row item enquiry date and booking date can be different because of which if i choose column as enquiry date(createTime.date) count of booking gets displayed on date of enquiry date.

For example in above screenshot on 1st november enquiry count is 122 and booking count is 1 but scenario which i wanted to perform is that booking count should appear on 3 rd november since booking date was of 3rd november instead of 1st november.

is there any way to achieve the same ? if not then is it posible to achieve in some different manner ? 

[v-xuding-msft]

Hi @joyb ,

Could you tell me if your requirement has been implemented? If it is, kindly share your solutions. More people who have the same request will benefit from here. If you are still confused about it, please share a sample table and your expected output to us. 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft]

Hi @joyb ,

Can you please share some sample data? For the screenshot, I'm not clear about your actual scenario. 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.