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