Using alternate states in Dimensions

[Anonymous]

Hello,

i need to use use alternate states in dimensions or alternatively without an operation like sum, count,etc..

Is it Possible?

Thanks in advance,

Regards

[Gysbert_Wassenaar]

Why? What are you trying to do?

[Anonymous]

i make a table like this, that doesn't have espression ( Rating Fitch is a simple dimension)...but i need that Rating Fitch is variable depending from DATE state 1 and DATE state 2 so as to be able to compare the trend...

[Gysbert_Wassenaar]

Your screenshot looks like a pivot table with two dimensions and one expression. And I still don't understand what you're trying to do. Perhaps you can give an example of the source data and the result table.

[Anonymous]

I have 4 fields: Bank Group,   Bank Group Country  , [Rating FITCH], and the Date pertaining to the rating.

I need to compare the trend of Rating FITCH: for example i want see in ste same table Rating Fitch od 1/01/2015 and the

Rating Fitch of 01/05/2015...I think it was possible with an alternate state

result table:

Bank Group	Bank Group Country	[Rating FITCH] State 1	[Rating FITCH]State2
AGENCIA DE FOMENTO DO PARANÁ	Brasile	BBB	BBB
AGRICULTURAL BANK OF CHINA	Cina (Rep. Popolare)	A+	A+

Date State 1	01/01/2015
Date Sate 2	01/05/2015

[Gysbert_Wassenaar · Accepted solution]

Sure, that shouldn't be a problem. Use two expressions:

only({State1}[Rating Fitch])

only({State2}[Rating Fitch])

[Anonymous]

thanks a lot!!!