How to show dimensions from different tables side by side in Pivot Table?

[#1]

Hi All,

I need to solve this:

my pivot table is currently showing 3 columns; Teaching Detail, Status, Remarks.

For Status, it is displaying in 1,2 or 3.

I need to replace this Status column with my [Rating Label] which are in text.

Can some one guide me on how to go about this?

I have attached the qvw for your convenience.  Please refer to CME tab for easy reference.

Thanks!

Chun Wey

[amit_saini]

Chunwey,

Inline will work here:

Load * Inline[

Status, Rating_Label

1, Rating1

2,Rating2

3,Rating3

]

Resident Your_table;

[#3]

Hi Amit,

thanks for your response.

I already had this table in my table structure.  It is linked by RatingID as the key.

[tresesco · Accepted solution]

Try expression:

=If([Question Labels]='Status',

Only({<QuestionType={'CME'}>}RatingLabel) ,Only({<QuestionType={'CME'}>}QuestionData  )

)

[amit_saini]

Oh Sorry,

If this is the case , it can be possible with Applymap function.

See this attachment.

Thanks,

AS

[#6]

Thanks Tresesco for the Only expression.  I will rmb to use this more often.

[#7]

Thank for your attached QVW. It is more helpful..