Skip to Content

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

Problem in display of char. and key figure for yearly query

Hello all,

I got a query in which i have to do restriction on

Calendar Day/Month in Rows under Material which is a Characteristics

So it should be

PACKAGE QUANTITY

JAN FEB MAR APRIL.......DEC

PACK1

PACK2

PACK3

PACK4 for current year

PACK4 for prior YEar

Now the months display is not pre decided, it can be anything as per the input of user.

So i have to restrict it on Calendar month for Material twice

In current year , just introducing the Interval range variable

In previous year, same restricition with offset -12

Now the problem is while displaying it shows

JAN'06 JAN'07 FEB'06 FEB'07 MAR'06 MAR'07........

PACK1

PACK2

PACK3

PACK4 for current year

PACK4 for prior YEar

Which is not desirable.

I only want value for Jan in one column

and for previous year and current year in different rows thats it.

If i remove Calendar year/month from columns there is no way I CAN DISPLAY MONTHS .

How to achieve this.

Please suggest.

Former Member
Former Member replied

the variable might be ok but the characteristic in the columns should just be period not fiscal year/period

0 View this answer in context

Helpful Answer

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