Dimension

[n1ef5ng1]

Hi all ,

I have a dimension call Places, inside the places there is field that is call 'Europe','America','Asia','South America'

For my Table, I would want to add a 'ALL' field inside the dimension (Place), is there anywhere I can do this without editing the script or using sub-total

basically, ALL contains the value of the four fields and are suppose to place the four fields in the same column

[Gysbert_Wassenaar]

No, not if you want to be able to select that ALL value. That's only possible if you create a new field in a new table:

NewPlaces:

Load * inline [

NewPlace, Place

All, Europe

All, America

All, Asia

All, South America

Europe, Europe

Americe, America

Asia, Asia

South America, South America];

Now you can use the NewPlace instead of Place. If you select All you get all places and if you select another value you get only that place.