sum() across all dimensions regardless of selection but one

[Anonymous]

How can I modify

     =sum ({1} Hours)

such that I sum across all values (regardless of selections) except for one given dimension?  I can ignore

one dimension by doing this:

     =sum( {$<dim1=,dim2=,dim3=>} Total )

I need to aggregate across the unspecified dimensions instead. Is that possible?

roman

[sunny_talwar · Accepted solution]

unspecified dimension? What exactly do you mean? Are you looking for something like this

Ignore all dimensions, except for one

[woshua5550]

Let's say you want ignore all user selections except "Product"

You can go like this

Sum({1<Product = P(Product)>}Sales)

[jonathandienst]

There is a difference between the options above

This syntax gets all POSSIBLE values for Product

Sum({1<Product = P(Product)>}Sales)

This gets all SELECTED values for Product

Sum({1<Product = $::Product>}Sales)

[tresesco]

I had created a document to discuss this in details :Ignore all selections except few fields using Set Analysis

[Anonymous]

All - Thank you!  I did come across P() / E() functions but didn't quite grasp how they work . This helps!