Running total by hour

shophoney

Board Regular
Joined
Jun 16, 2014
Messages
212
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
 

Forum statistics

Threads
1,077,849
Messages
5,336,734
Members
399,100
Latest member
darcob

Some videos you may like

This Week's Hot Topics

Top