Cross Tab - Output Row for each line rather than summary?

[loopist612]

Is there any way to force the cross tab to repeat a summary row for a multi level crosstab? In the example below, I have date as the top level, and hour as the secondary. I'd like each row to have the date and hour since this will be exported into Excel by our end users and filtering applied (Excel doesn't work nice with that first column being a merged one).

For example:

I've tried a few different combinations of this, but still with the same result:

[loopist612]

Ok, I think I figured out a work around. I saw a lot of people asking this same question without finding a great solution, so I'm going to document here in case anybody else comes across this. I changed my Date column to have date and hour ('MM/DD/YYYY HH24') So then I was kind of duplicating the hour aggregation. Then I wanted to just remove the hour from the top level dimension when the report was written. I thought you could just do a string replace on that row dimension (dimension["DateTime"]["V_DATE"]), but you can't, at least I couldn't find a good way. I did though see you could change the data binding, and instead of the dimension in that row, you can just use the column binding. In my case, I edited the data binding for my column that I changed to "01/01/2023 01".

And then replaced the output value back to just the date: