Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.


Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question