Hi Eirik,

Please tell me for both Multi dimension and Tabular ?

Many Thanks,
Raj

Hi Eirik,

The Intended target platform is SQL Server...

Hi Thom,

Below is the query I've tried and it working. 

GO
SELECT *FROM YourTable;
WITH CTE AS ( 
SELECT *,    ROW_NUMBER() OVER (PARTITION BY BOOKING_NUM ORDER...

Hi Thom,

Thank you so much the query worked like a charm 🙂
I have another issue can you help me with the query, please?