Hi guys
I saw that there are some posts over this issue but I still couldn't find a solution to my case.
I have a Bex query with 2 structures
1 with period selection on the columns like Quarter 1, Quarter 2, Difference etc
2 simple structure with key figures.
When I see them in CR i get all key figures and an additional "Characteristic" for structure 1
I want my report to look like a crosstab as it looks in Bex, but I get a row for each element in structure 1 in stead of column
Quarter 1, Quarter 2, Difference
Sales QTY 100, 200, 100
And I get
Quarter 1
Sales QTY 100
Quarter 2
Sales QTY 200
Difference
Sales QTY 100
Please help
Shlomi