display heading in report

[Former Member]

2006-2007

COMPONENTS March April May June July

INDIAN 116.7 116.95 114.6 96.41 96.05

IMPORTED 216.83 187.55 250.12 223 223.69

PACKING MATERIAL 4.85 6.52 5.65 6.75 4.9

Total-Inventory 391.33 352.01 352.06 352.01 352.01

I can get these values from 0ic_co3

I will get the Indian if I take Valuetype = Land1 (Indian) ,KF Amount

Imported I get Valuetype = Land2 (Imported) ,KF Amount

Stock in osp I can get using Mat type & VERP ,Amount

I can create restricted keyfigures on these but it displays me the data like

This in report

Indian 540.7( showing me the total of all months)

Imported 1101.19

But I want the report to display for individual months i.e I enter the value 2007 in the selection screen then it should show me for individual months what is the value

i.e it should display the heading like this how is this possible

COMPONENTS March April May June July

Regards

Maya

[former_member188325]

Hi,

Place 0CALYEAR in Filters and create a variable to input Year.

Place 0CALMONTH in columns and use text variable to display text of month.

if you want to display months > current month, restrict 0CALMONTH with 0CMONTH (current calender month).

From context menu of 0CALMONTH>restrict>select 'Value range' and 'greater than' for Selection and move 0CMONTH to right side-->Ok.

Thnaks

Message was edited by:

Murali