How to make a alternate state part of a dimension

[#1]

Hi,

I have the alternate state and I want I a pivot table that the dimension cars should have the alternate state {Home}. How to do this?

only({Home} cars) didn´t work...

[sunny_talwar]

You want just one dimension to be from another state or all the dimension?

[swuehl]

Your dimension should be dimensional, not a single aggregated value, so at least try

=Aggr( Only({Home} cars), cars)

edit:

But you may also need to look at your expressions. I think it would be better if you explain your requirement in more detail, best by also uploading some sample data or sample QVW