2 Replies Latest reply: Aug 17, 2012 1:21 AM by Thorsten Edler

# Display of monthly balance in chart.

Hello.

I have a chart with monthly sum of sales over a period of a year and would like to show the balance between each month in the same chart, but am having problems.

I'm using this set analysis expressions

Tables :    - year: (2008,2009,2010,2011)

- month: Numbers between 1 and 12

- balance : net sum of monthly sales

Dimension :           month

expression 1 :        = sum( {\$<year={'\$(=year)'},Monat={'\$(=month)'}>} balance )

expression 2 :        = sum( {\$<year={'\$(=year)'},Monat={'\$(=month - 1)'}>} balance )

expression 3 :        = Column(1) - Column(2)

The problem is that its just working when I select one month.

But I need to display it for every month in the chart as a whole.

regards

Thorsten Edler

• ###### Re: Display of monthly balance in chart.

If Sum(Balance) is your first expression then try this as your second:

Sum(Balance)-Above(Sum(Balance))

Hope this helps,

Jason

• ###### Re: Display of monthly balance in chart.

My dear friend,

this is perfect!

:-)

Thorsten