Create a hierarchy for values in one column

I have a column with a series of value like= JAN-18, FEB-18, MAR-18, ... , Q-1-18,...Q-4-18, Y-18, Y-19 etc... I need to create a Hierarchy on Spotfire which allows users to visualize details for marked values:

Suppose I have a graph with 3 lines, each for Y-18, Y-19, Y-20.

I would like to be able to choose an Year and drill down for quarters and months. Ex: An user interested in Y-18 should be able to see Q-1-18, Q-2-18, Q-3-18, Q-4-18 data by clicking on year curve.

I thought a hierarchy would have been the best way to do this but what I see while inserting it is only columns, without the possibility to specify parameter for each column and I have only one column called "ProductType" for all this data.


File desiderata.xlsx96.35 KB

(1) Answer