Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Can anyone help me have a column with cumulative sales info from the beginning of time in my data i.e. Jan 2008?
Thanks
C
swuehl, thanks for the help. I used a mixture of your suggestion and a bit of research into other things and came up with what I needed. It looks something like this -
=sum({<[Transaction Date] = {"<=$(=max([Transaction Date]))"}, Year, Month>}Sales)
Seems to work so far.
Thanks again
C
Try an expression like
=rangesum(above(sum(Sales),0,RowNo()))
Thanks swuehl, that is exactly where I am currently. However I need to go one step further.
What do I add to the expression so that I can select 2009 and April from the dimension and it then I still get a cumulative from Jan-2008 through to April 2009?
Maybe
=rangesum(above(sum({<[Transaction Date] = {"<=$(=max([Transaction Date]))"}, Year, Month>}Sales),0,RowNo()))
That works! thanks.
Now my issue is if I replace the date dimensions with the Products it doesn't work. I want a tbale that gives me sales to date (right from the beginning of time) for each product. I initially simplified it think that the next bit would work fine.
Then your SalesToDate expression might be a good start. What about changing it to
=sum( {$<[Transaction Date]={"<=$(vEnd)"},Year,Month >} Sales)
swuehl, thanks for the help. I used a mixture of your suggestion and a bit of research into other things and came up with what I needed. It looks something like this -
=sum({<[Transaction Date] = {"<=$(=max([Transaction Date]))"}, Year, Month>}Sales)
Seems to work so far.
Thanks again
C