Year over Year report
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
calendar month year
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.
Edited by: kartikey on Oct 1, 2008 3:16 PM
Patrick Byrd 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?