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

Display parallelPeriod MeasureValue

Started by PNevill, 28 Mar 2016 07:17:25 AM

Previous topic - Next topic

PNevill

I have researched this for 2 days and no luck ... looking for help now.

I have a Dimension set (Departments) going down in a crosstab.  I have 10 weeks within a Year going across.
Along side the Department I want to show the Current Weeks (across members) Sales value.  No problem so far.
Right below I wish to show the same period 1 year ago just beneath the Current Week Values.  I cannot figure out the syntax for this (if possible at all).
Here is the format"
     (Net Sales)             Week 1    Week 2     Week 3     Week 4
Dept 1   Current Yr         565         453           612           712
             Previous Yr       
Dept 2   Current Yr         582         523           634           801
             Previous Yr

In the top crosstab corner is a default measure (Net Sales)  in the Current Year cell I use the following:

total ( currentMeasure within set periodsToDate ( [Sales].[Calendar].[Standard Time Hierarchy].[Fiscal Week] , currentMember ([Sales].[Calendar].[Standard Time Hierarchy] ) ) )

I tried various combinations with parallelPeriod but to no avail.   Help is greatly appreciated!