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

Using 'within set'

Started by DhimanBiswas, 08 Apr 2014 07:08:55 AM

Previous topic - Next topic

DhimanBiswas

Hi friends,

I have one doubt here; please help.

Attached is a chart that I have created. Package is of DMR nature.
Series has a column called [Source of Feedback] where a slicer is applied to display only [CFPB] and [FRB] members. Additionally I need to display CFPB% as ( complaint volume for CFPB / complaint volume for CFPB across all quarters selected ). I am not able to find the expression for the denominator here.

What I used is:

_format (  (  total ( [Complaint Volume] within set [CFPB] ) /  total ( [Complaint Volume] for report )  ), PERCENTAGE_2 )

which is not right.

Can you please help me get the right expression?