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

90 Day Sales Moving Average

Started by johny.cbi, 22 Jan 2008 08:58:56 AM

Previous topic - Next topic

johny.cbi

Display 90 Days Data in Sparkline Chart (eg;- current Month, Current Month-1, current Month-2)
The data is coming from cube (MDX)

I've Measure(Y-Axis)
expression on Y-AXIS

average([Sales Cube].[Measures].[Sales Amount] within set filter(lastPeriods(90,currentMember([Sales Cube].[Date].[Date])), tuple([Sales Cube].[Measures].[Sales Amount],currentMember([Sales Cube].[Date].[Date]))<>0))

I am using the following expression on X-AXIS

tail([Sales Cube].[Date].[Date].[Day],160)

with this result is coming wrong

my question is

I need the data for 90 days (current Month, Current Month-1, current Month-2) on X-AXIS