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

Help in Filters

Started by deepak2k2, 09 Nov 2010 10:05:25 AM

Previous topic - Next topic

deepak2k2

Hi,

I've a scenario to create a list with filters.  I need a create a measure in such a way that Revenue of filtered item/total Revenue.

Ex:  Using value prompt, I've chosen India.  Then I need to calculate the measure (%) as
Revenue (India)/Revenue (Overall).

How to find the overall revenue in my filtered list?  Which function will give the overall revenue?

rockytopmark

You could try something like:

total(If ([Country] = ?pCountryPrompt?) then ([Revenue]) else (0) for report)/total([Revenue] for report)

deepak2k2

Thanks for your reply.

I'm getting the below error message when I use the code "Total([Revenue] for report)"

Error:  "The 'For Report' clause is not supported with sibling valueSets or edgeGroups."

yattishr

Has anyone managed to find a resolution to this issue as I am experiencing a similar problem
I am also getting the same error message as:
"Error:  "The 'For Report' clause is not supported with sibling valueSets or edgeGroups."

Thanks,

ksr

Hi,

I think you are using dimensional package. In such case use level in the expression instead of Hierarchy

and remove the filter line on country from the filter and dont remove the prompt.

take a query calculation and add the following expression

total(if([country]=?cParameter?) then ([revenue]) else (0) for report)/total([revenue] for report)

note: As I told you, the [country] in the above expression should be level in the hierarchy

even if you get error, please describe your problem in detail...

regards
KSR