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

Crosstab Measures Conditional formatting

Started by guy222kool, 07 Dec 2012 02:41:24 PM

Previous topic - Next topic

guy222kool

Hello,
I have a specific requirement where in I need to format a Measure of a particular member comparing with the measure of a different member.
I have posted detailed snapshots of the type of formatting that I'm expecting to achieve.
Whenever the Quantity of Email(Order Method) is greater then the Quantity of Telephone(Order Method) for a specific Month, I need to highlight those specific measure cells.
I am using the Members of the Order Method Level, nested under Region Level as Rows and Months as columns(explained better in Image: Report Design).

I have tried to base the Conditional formatting on 2 Data items that I have added to the Query.
A: total([Quantity] within set [E-mail],[Month])
B: total([Quantity] within set [Telephone],[Month])

and created  a Style variable as: A>B
Now the issue is, the data items seem to calculate the Total sales of E-mail and telephone for all months and hence the whole Row of E-Mail Order method for Americas is being Highlighted.
Where as I only want specific Month's Quantity values of E-mail and Telephone to be compared. Ex: Jan-Quantity of E-mail compared to Jan-Quantity of Telephone and so on.(I have marked the Cells which need to be highlighted in Image:Report Output)
Is it possible to retrieve Measure values of Intersecting members and compare them?

Please let me know if anyone had faced such a scenario before and a possible solution to this.

Bark

The expression "total([Quantity] within set [E-mail],[Month])" will indeed add all the months together as that's what [Month] contains. If you leave it as "total([Quantity] within set [E-mail])" should work fine as the context is defined by the intersection itself but if you want to be certain, the expression for only one month at a time would be: "total([Quantity] within set [E-mail],currentMember(hierarchy([Month])))".

Regards,

Bark