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?
You could try something like:
total(If ([Country] = ?pCountryPrompt?) then ([Revenue]) else (0) for report)/total([Revenue] for report)
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."
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,
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