13 Replies Latest reply: Apr 28, 2015 9:39 AM by Navas Khan

# Monthly Variance Daynamically

How can i plot the the monthly variance in my chart?

I have the cummulative data.

Example:

 Year Month Sales 2015 Jan 10 2015 Feb 40 2015 Mar 30

The chart should show the values

Jan 10

Feb 30

Mar -10

The chart show dynamically the month based on availability of data.

Note: I am using calaender function in my application

• ###### Re: Monthly Variance Daynamically

my expression is

alt(sum(Sales)-above(Sum(Sales)),sum(Sales))

• ###### Re: Monthly Variance Daynamically

Thank You !

• ###### Re: Monthly Variance Daynamically

How can i plot this in Trend Chart?

• ###### Re: Monthly Variance Daynamically

with a calculated dimension and same expression

• ###### Re: Monthly Variance Daynamically

i have another dimension on top of that which shows the actual amount instead of variance when i plot that

• ###### Re: Monthly Variance Daynamically

My data is lke :

Income Jan 200

Income Feb 250

Expense Jan 300

Expense Feb  450

The Chart Should show Monthly Income Varince and Expense Variance

I.e

Jan    Feb

Income     200      50

Expense   300     150

• ###### Re: Monthly Variance Daynamically

alt(sum(Expenses)-above(Sum(Expenses)),sum(Expenses))

• ###### Re: Monthly Variance Daynamically

That works fine . Thanks for your support.

How did you hide the Chart Label.

i.e when i create the legend the first Ledgend  Label is appearing in my chart. How to come out of that?

• ###### Re: Monthly Variance Daynamically

Hi,

Uncheck Show Title in Chart option in

Chart Properties -> General tab.

Hope this helps you.

Regards,

Jagan.

• ###### Re: Monthly Variance Daynamically

Thanks Jagan.

Hot to bring my Legends from Right to Down in Horizontally.

Example :

From :

Income

Expense

To :

Income     Expense

• ###### Re: Monthly Variance Daynamically

Hi,

Horizontal Legend in chart

Regards,

Jagan.

• ###### Re: Monthly Variance Daynamically

shift + ctrl

then drag the red rectangle to the top/bottom

• ###### Re: Monthly Variance Daynamically

How to forecast the variance for the rest of the months?