Skip to Content

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

How to filter two different data sets into Chart component

Hi!

Here's my problem: I need to show the current year's YTD actual revenue data on a column chart (e.g. 001.2014 - 008.2014). This is simply achieved by range filtering the 0FISCPER accordingly by range mentioned above.

Now, I want to see also Previous Year revenue values in the same chart next to current year's actual revenue data for comparison. The problem is that PY data has 0FISCPER values 001 - 008.2013 and now the datasource is already filtered to show only 001 - 008.2014 data:

1st  column on the chart:    Current revenue            ( 0FISCPER : 001.2014 - 008.2014 )

2nd column on the chart:    Previous year revenue  ( 0FISCPER : 001.2013 - 008.2013 )

Current revenue and PY revenue are individual measures in the query so with current test data, if I select 2013 data I see only PY measures and if 2014 data is selected I see only actual revenue figures.

How can I get both current actual revenue data and previous year revenue data to be shown in the same chart with SAP BO Design Studio  (without modifying the underlying query ). From 2013 I would only want to see PY value, nothing else. This might be trivial task but I just could not get it right...

Tags:
Former Member
Former Member replied

Hi,

This is something you will have achieve in your Query, because as far as i Know there is no way to do it on the Front end of Design Studio

Regards,
Fazith Ali Z

0 View this answer in context

Helpful Answer

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