TM1 Forum

Hierarchy->
Countries dimension.
Hierarchy - Country ->USA->EAST,WEST,NORTH, SOUTH ->states.

Now the report should look like
Sale
Product category NORTH 50
EAST 100
West 150
South 200

Now the issue here is user doesnt want one state under South to be shown in report , South should include state Florida, when he expands south he should not see florida and total of south should not include florida's sale as well.

So what I did was created a public static subset ,called SouthMinusFL and excluded florida from the lowest level member .

Then I created a subset and pasted all three values NORTH ,EAST ,WEST and SouthMinusFL and saved as CustomSubset .

Now in the report view for this countries dimension I inserted this CustomSubset using edit insert subset .

Now the view looks like
Sale
Product Category Customsubset 500

Now all looks good , but on expanding this custom subset ,

the values shown are North
East
West
instead of south I have all states except florida .

Is there a way the rolled up SouthMinusFL will be shown .


Thanks,

This is pretty hard to follow but if I can venture a guess:

subsets do not change the way elements (consolidations) expand to their children.
You need to create custom rollups (consolidations) if you want to have different calculations / different ways to expand a consolidation, and so on.

If this is not your issue, please be clear and add screenshots. This isn't sensitive data, is it ?