Set Analysis Question

[#1]

Hi Everyone

Please can someone help me with this:

I need to keep this static .i.e does not change with the current selection:

sum(TOTAL GArevenue)

GArevenue changes with the current selection.

Thanks

Vaneshan Naidoo

[senpradip007]

Try like

sum({1} TOTAL GArevenue)

[#3]

Hi Pradip

Nope, I tried that - doesn't work. It inflates the TOTAL to much higher the an the true value.

[ashfaq_haseeb]

Hi,

Try below

sum({<YourMonthField>}TOTAL GArevenue)

Add all dimension you don't want filtering

Regards

ASHFAQ

[#5]

Hi,

Then exclude only the fields which you do not want the expression to get affected.

Example:

If you do not want Selection in the field Country to effect you expression then use:

sum({<Country=>} TOTAL GArevenue)

[senpradip007]

Could you upload your sample qvw?

[aveeeeeee7en]

You can By pass the Selections like this:

1. sum(TOTAL{Field1=,field2=} GArevenue)

2. Sum(Total <FieldName=> GArevenue)

3. Sum(Total <FieldName1,Fieldname2> GArevenue)

Regards

Aviral Nag

[#8]

Hi,

It still doesn't work, the problem is that GArevenue changes as selections are made.

The full expression is :

sum(GArevenue)/sum(TOTAL GArevenue)

When I click on anything in the front end, it changes the value of Sum(GArevenue) which is fine BUT is don't want to TOTAL sum(GArevenue) to change as this is used to calc the % proportions.