How to compress result rows for below

[Former Member]

Team,

How to get the above output in 2 rows instead of 4 rows?

Is there any settings available to compress?

Thanks,

Balaji K S

[Former Member]

HI All,

Thanks, I have checked this settings, problem is lines are compressed but Getting constant values for Key Figures.

FYI : Report is created on Multiprovider and below info providers have this 0CALMONTH on it.

Thanks,

Balaji

[umashankar_poojar]

Hi Balaji,

Thanks for the update, did you manage to solve the problem? does any of the responses are helpful?

Thanks,

Umashankar

[Former Member]

HI Umashankar,

Thanks, I have checked this settings, problem is lines are compressed but Getting constant values for Key Figures.

FYI : Report is created on Multiprovider and below info providers have this 0CALMONTH on it.

Thanks,

Balaji

[RafkeMagic]

read my previous reply

you have 4 different characteristic values in the rows... hence you have 4 different lines

if you want to show this on two lines, you can either do so by showing only the period in the rows or only the year (in your example)

or make sure the key figures refer to the same periods

[Former Member]

Thanks Raf, Yes Key figures are referring different periods.

It's a comparing Current year month and Previous year.

Thanks,

balaji

[former_member183012]

Hi Balaji,

These two key figures coming from different info provider that's why showing like this. Can you check constant selection for this..try once.

Regards,

Ganesh Bothe

[former_member186053]

Hi Balaji,

As mentioned by Umashankar, you can use 'constant selection' option in query, please go through the below link.

https://help.sap.com/saphelp_nw70/helpdata/EN/e7/5f983c1a356858e10000000a114084/content.htmhttp://wiki.scn.sap.com/wiki/display/BI/Constant+Selection+and+Overall+Result

Regards,

Vengal.

[RafkeMagic]

by putting the calendar year in the columns (and leaving the monht/period in the rows)

(or by making sure your key figures are filled for the same periods)

[umashankar_poojar]

Hi Balaji,

        If the two KeyFigures are from two different InfoProvider and Report is fetching this information on MutltiProvider. Then Constant Selection would help you to fix this problem.

Search SCN on Constant Selection, you will find plenty of threads and docs to explains it.

Thanks,

Umashankar