Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
You want just one dimension to be from another state or all the dimension?
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