Skip to Content
0
Former Member
Sep 25, 2008 at 04:28 AM

BEx report format

34 Views

Report requirement:

Query contents:

Characteristics:

Calweek, Calyear, Calday, Calmonth

Material, Customer.

Drill down in rows: Material, Customer

Key Figures:

K1, K2, AND K3

Variable selection:

Calmonth.

User will enter a month range: Suppose January to April.

Output should look like

Rows: Material and custmer.

Columns: Key figures should have a top row of calmonth..i.e. bukets of month.

Jan Feb March April

k1 k2 k3 k1 k2 k3 k1 k2 k3 k1 k2 k3

How do I get month on the top of key figures. There should be a common (cells merged) month display over k1, k2, k3.

Thanks

Shankar