I need to add trend lines for a dimension say 'Category' (values 'A', 'B') in a column chart that has a measure and date as the dimension. The measure is common for both the dimensions, Category & Date. The trend lines should appear in addition to the existing vertical bars as shown in the drawing in the attachment. Please let me know if this is possible, if so how?
I tried using the combination column with line option but it does not work. Even if I add the Category dimension to color, it is reflected in both the existing bars and the new lines included. Please suggest.