Using alternate states in Dimensions

[#1]

Hello,

How can you use alternate states in dimensions?

In a scatter plot i have 2 dimensions A and B, where B is an alternate state of A. How can i use an alternate state of A as a dimension in a chart?

Thanks in advance,

Regards

[Anonymous]

did you get a soultion for this? i have a similar problem.

[#3]

Nop. I had to change the database model. Try creating a copy of the table.

[#4]

I got mine to work using the following:

=Aggr(Max({$<POSDate=P({[Alt Calendar]})>}POSDate),POSDate)

POSDate is my dimension, but it needed to be limited by my alternate state (Alt Calendar).