Trying to build a running total by hour

[shophoney]

Hi I'm trying to build a formula that has the running total by hour.

I use CUBE members

Here is the hourly cube:
=IFERROR(CUBEMEMBER("ThisWorkbookDataModel","[TIME].[TIME].&[1899-12-30T10:00:00]"),"")

This is the sales formula pointing to the hour above.
=N(CUBEVALUE("ThisWorkbookDataModel",$A7,"[Measures].[SALES TOTAL NET RETAIL 1000]",Slicer_CURRENT_DAY))

I want to see the running amount only up to this hour. If the CUBEMEMBER hour is future then blank.

I hope this is clear. Hard to explain.

Thanks