Total vs Detail Trend line Graph in Design Studio
Hi DS gurus,
I'm using Design Studio 1.2 version and have a requirement to show/compare a trendline graph of total values w.r.t detail values of different category. Here are the attached my Trendline graph and Data sets.
This is how the requirmenet goes
1) I have a drop down of various categories like Vendor, Equipement, Material (refer dataset attachment)
2) The trendline graph needs to compare total values (of all categories) w.r.t a selected category (value from drop down). refer the graph attachment.
3) I have only one measure in my data set. I want to display that as two different data points in the trendline graph(one for Total and one for the selected category).
When I select a value from the downdown, the total also changes accordingly. I like to keep the total values unchanged when I select a category. Is there any way we can do that in DS ?
It's easy in WebI, where we can create a variable measure for a the selected category and we can use the total and the variable in the graph as two measures.
Please let me know if you have further question.