http://forums.visokio.com/discussions/tagged/cumulatives/feed.rss Mon, 30 Oct 17 17:04:54 -0400 Tagged with cumulatives - Visokio Forums en-CA http://forums.visokio.com/discussion/2581/pivot-view-running-ytd-total-across-columnss Fri, 06 Jun 2014 13:09:15 -0400 s_daffern 2581@/discussions
So in 2013 quarter 1 we spent £50, in quarter 2 we spent £70 with the period total then being £50 + £70 = £120. I would then compare 2014 quarter 1 against 2013 quarter 1in the pivot.

Apologies if this is simple I just couldn't seem to get it to work using the Running Total formula.

Thanks, Steve]]> http://forums.visokio.com/discussion/2114/formulae-cumulative-figures-and-runningtotal-example Wed, 01 May 2013 02:00:44 -0400 windsymphonic 2114@/discussions
Company Name | Date | Daily Sales
ABC | 22/03/2013 | 22
ABC | 22/03/ 2013 | 23
ABC | 23/03/ 2013 | 40
ABC | 23/03/ 2013 | 50
DEF | 22/03/2013 | 10
DEF | 22/03/2013 | 20
DEF | 23/03/2013 | 30
DEF | 23/03/2013 | 60

In Omniscope, I have aggregated by Company Name & Date which gives me:

Company Name | Date | Daily Sales
ABC | 22/03/2013 | 45
ABC | 23/03/2013 | 90
DEF | 22/03/2013 | 30
DEF | 23/03/2013 | 90

My next step is to calculate cumulative sales by company name & date. So I want my outcome to be:

Company Name | Date | Daily Sales | Cumulative Sale
ABC | 22/03/2013 | 45 | 45
ABC | 23/03/2013 | 90 | 135
DEF | 22/03/2013 | 30 | 30
DEF | 23/03/2013 | 90 | 120

So how do I derive the cumulative sales?

Cheers, Firman]]>