Help with CubeValue Funtion to calculate YTD sales

Dear All

I was wondering whether some one can help me with the following problem with the CubeValue Formula

I am designing a dashboard wher I have used CubeValue Function to return the sales for the chosen period based on the user's input

my formula is shown below

Please Login or Register  to view this content.

What I want to do now is to also calculate the YTD sales , so if user enters 5 in cell B1 then I can also show the sales cumulative sales from Period 1 to Period 5 as well as the sales fro Period 5 (from formula above).

Is there an easy way to do this without having to use Getpivot data function as I do not want to create any pivot table.

Any help is appreciate it.

Thak you so much for your help xlintwit. It worked like a treat.