Running total by hour

shophoney

Board Regular
Joined
Jun 16, 2014
Messages
219
Hi, i'm trying to build a running total by hour.

I have a power pivot CUBE formula for the time:
=IFERROR(CUBEMEMBER("ThisWorkbookDataModel","[TIME].[TIME].&[1899-12-30T10:00:00]"),"")

And what i need is to see the total up to this hour. I'm pulling in last years values. If the hour is after now then blank, else put in LY running sales.

=N(CUBEVALUE("ThisWorkbookDataModel",$A7,$A$2,"[Measures].[1YR AGO SALES NET RETAIL]",Slicer_CURRENT_DAY))

A2 is the location look up, and A7 is the hour look up.

Thanks
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,095,556
Messages
5,445,194
Members
405,320
Latest member
daverosati1785

This Week's Hot Topics

Top