Skip to Content

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

Year over Year report

Hello,

I need to build following report-

Jan08 feb08 march08..nov08 jan07 feb07 march07.. nov07 Median08 Median07

Now user wants to see the keyfigure Cases Ordered for all this months in keyfigure.

later want to find the Median value of Keyfigures for January to November.

Now the Month range January to November is not fixed, user wants the flexibility to see any number of months in any order for e.g. (jan to march, or feb to sept. or aug to oct etc)

I have Company number as characteristics in Rows.

What i did ?

I have company number in Rows

24 Restricted Keyfigures in Columns in total,

22 kf are for 11 months each for current year & previous year, 2 kf with formulae to find median.

Now i cannot use Calendar Month & Year in columns like below

COLUMNS

calendar month year

keyfigure structure

current year cases

previous year cases

Because i also need to create formulae, so i cannot use above design.

So i have to build 22 restricted keyfigures.

Now question is , if user is running the report from jan to august, the other keyfigures for sept. oct & nov. still shows up.

They dont display vallues but blank columns still shows up.

How to remove those?

I used Supress Zeroes from Rows & Columns, but this does not get rid of empty columns.

Please advise

Edited by: kartikey on Oct 1, 2008 3:16 PM

replied

When I did something rather similar to this, I had to use Boolean logic in the Calculated key figure to ensure the data isnt reported for months you don't want to show.

But I'm not sure the answer isnt simpler than that... you say you have used zero suppression, but I guess you mean you have done that within query properties? Try saving the key figure structure as a global structure, when you do that check the box that says 'Also use zero suppression for structural elements'.

Hope that helps... points?

Patrick

0 View this answer in context

Helpful Answer

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