If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

LINE CHART, maybe someone has an idea

Started by Jeka, 18 Sep 2008 10:28:30 AM

Previous topic - Next topic

Jeka

Hi Guys,
I have been looking for the answer everywhere and no one has answer to my question.  Hopefully someone experienced the same problem!

I created a line chart with makers for YTD (on my x-axis), shows every month for YTD.
I got two lines: showing revenue in series (measure) and expense in series (also a measure).

Is it possible to add 3rd line that will be PARALLEL to other lines in the same chart and will show Prior YTD Revenue but the X-axis  still  will show current YTD?

I created total([Revenue} within set [Prior YTD]) and dragged into the series but that is not working!
Thank-you!
Nikki

billylodz

use trick
add

lag([Selected Month],12)   for last year
next periodsToDate([xxx].[All Time Periods].[All Time Periods].[Year],[Selected MonthLY])  for YTD Months - LY

in crostab second item add to column
and in rows add one more revenue

next hide cells in 1st revenue for current year
and hide cells in 2st revenue for last year

benjaaz

Look at adding the data item as a marker like a goal.  Markers are just below the Y axis stuff on the chart.