This function represents all Members in a Dimension.
Syntax
All( <Dimension> )
Parameters
<Dimension> : A Dimension.
Description
Returns a single Member representing the aggregation of all Members in <Dimension>.
Example
Consider the following raw data:
| Product | Store | Sales |
| Shoes | Store A | 10 |
| Shoes | Store B | 20 |
| Shoes | Store C | 30 |
| Shirt | Store A | 40 |
| Shirt | Store B | 50 |
| Pants | Store A | 60 |
| Pants | Store C | 70 |
( [Sales], ALL([Product]) ) = 280 {10+20+30+40+50+60+70}
( [Sales], [Shoes] ) / ( [Sales], ALL([Product]) ) = 0.214 {60/280}