Straight Table and Click behavior

[#1]

Hi All,

I have a question.

I made a table which has "status" as dimension and "Date" as expression and set Horizontal. But when I click a cell, it choose only "Date". I want to choose both "Status" and "Date".

I have to make a table in the layout and I don't use any filter. I want to do just one click and show up the drill down result in another object.

Please see attachment.

How can I make such a table keeping the layout? Do you have any idea?

Regards,

Yoshi

[#2 · Accepted solution]

Hi Yoshi

I tried it with a pivot table using only date and status as dimension and number as expression. When you click on a number it will select the date and the status...

See the qvw attached:

Let me know if this is what you were looking for.

regards,

Anthony

[#3]

Hi Anthony,

Thank you for your reply. Yes, that is what I wanted. I didn't know that I can drag & drop a dimension to another field on Pivot table too.

Thank you very much!

Yoshi