Hi.
I have a table with 5 attributes in which I am interested.
One attribute is Date, and the other Attributes I call them, A, B, C, and D.
Attribute can only have 2 values (non-numeric) , A1, or A2.
Attributes B, C, and D have numeric values.
I built a Metric Set with Date in Rows, A in Columns and B, C, and D in Measures.
An example of what I got is this the following table:
My goal is to create a graphic with 2 levels. At the first level, I see Date vs A with the values of B, C, and D without distinction (same colour and the same shape). Drilling down (by selecting A1 or A2), I see Date vs B, C, and D (for the selected A value).
I know it must be using Hierarchy, or Drill Down in Dashboard, but I am not getting it.
Could you give me some advice.
Thank you.
Best regards,