Can I get running totals in Report Builder?

manasdatta

11-05-2016

I'm trying to put together a little report with some marketing channels - trials, sales etc. by week over a 3 month period. 

I've got the data, but what I'd like to do is present the weekly data as a running total, and then compare that with different patterns. 

Is there any way to get a running total in Report Builder? 

Accepted Solutions (1)

Accepted Solutions (1)

Answers (5)

Answers (5)

manasdatta

11-05-2016

Hey Tanmay, 

Really appreciate your support :-). Attached is a little Excel sheet that will explain the kind of output I am trying to generate. I hope that this helps. 

Manas

TanmayMathur

Community Manager

11-05-2016

Hi M,

It would be great if you could show a sample structure of the report that you are willing to create. That would help me in understanding your requirements better. Thanks!

Tanmay

TanmayMathur

Community Manager

11-05-2016

Hi, 

If I understand your query correctly you want to have a report showing the data for the last 3 months with weekly numbers in a row and the last 3 months would be a rolling date.

In the Report Builder you can select 'Rolling Dates' and then specify 'Rolling weekly' and then under 'Apply granularity' also select week. I think this would give you the required result. 

Let me know if that solves your question. Thanks!

Tanmay