Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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