Skip to Content

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

BEx report format

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

Former Member
replied

In query properties.

Uncheck "Hide repeated key values" in display tab.

Hope this helps.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question