Dimension wise splitting measure expression

[Aditya_Chitale]

Hello All,

I want to create a table as shown in below screenshot.

1: count of units using Booking Date

2: Sum of SA using Booking Date

3: Sum of AV using Booking Date

4: Point 3 divided by point 2

5: Count of units using Cancellation Date

6: Sum of SA using Cancellation Date

7: Sum of AV using Cancellation Date

8: Point 7 divided by point 6

My concern is how to show measures based on two different dates at the same time against dimension values.

Is there any way to achieve this from frontend or will it require any backend scripting ?

Regards,

Aditya

[Aditya_Chitale · Accepted solution]

Its solved. I used a simple if statement in measure expression