Set Analysis Help

[muniyandi]

Hi All,

i need one help,i have more then 30 dimension filtration there in my qv doc.

below mentioned is my expression.

sum(total<Qtr,Region>  Amount)

user apply the filter  Qtr,Region time only this expression go to  filter , otherwise i need  sum(total<Qtr,Region>  Amount) full value to be display.

i am trying 

sum(total<Qtr,Region> {SubRegion=,City=............} Amount) , I follow up this method means,i will mention the all dimension value.

any Short cut available

Muni.

[its_anandrjs]

You are right but if in any expression you want to selection effect then you have to try like

sum(  total<Qtr,Region> {1} Amount)

[muniyandi]

Thanks anand.

It's Working. some other case it's failing.

sum(  total<Qtr,Region> {1} Amount) correct.  One more thing.  now i want filter only product dimension ,how to apply this expression.

Thanks,

Muni

[its_anandrjs]

This statement filter all dimensions

sum(  total<Qtr,Region> {1} Amount)

You have to use

sum( {1} total<Qtr,Region> {<product= >} Amount)

Or

sum( total<Qtr,Region> {<product= >} Amount)

[#5]

sum(total<Qtr,Region>{<Product=>}Amount)