Compounded Revenues formula for Bubble Chart (DAX? MDX?)

[mshparber]

Hi,
I am playing around with PowerView Bubble Chart - it looks very promising to "catch an eye" of my users (customer accounts managers) and it's pretty cool in terms of visualisation efficiency
I've noticed that if I "play" the chart by months, the bubbles (=customers) are jumping all over so it is hard to see the trends (jumps are sometimes because of seasonality or sometimes because one-time refunds etc.)

So, I thought that, instead of putting, say, "Revenues", on X axis, I'll put "Compounded Revenues" calculation (Which is the sum of all the revenues from the beginning of the year till every relevant month)
For instance, instead of showing
[TABLE="width: 500"]
<tbody>[TR]
[TD]Jan 2012[/TD]
[TD]Feb 2012[/TD]
[TD]March 2012[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]150[/TD]
[TD]100[/TD]
[/TR]
</tbody>[/TABLE]

I'll show
[TABLE="width: 500"]
<tbody>[TR]
[TD]Jan 2012[/TD]
[TD]Feb 2012[/TD]
[TD]Mar 2012[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]250[/TD]
[TD]350[/TD]
[/TR]
</tbody>[/TABLE]
This way, the plots will be less sensitive to fluctuations and also I will see that all the managers that start at 0,0 - where they end up at the end of the year.

So, my question is - any elegant way to calculate this "Compounded Revenues"?

Just for information - my FACT data table contains other columns so ("customer-month" isn't PK)
Thanks

Michael Shparber

 

[miguel.escobar]

it seems like you need Powerview and a really cool scatter chart with a play axis.