on 03-01-2011 7:08 AM
can crosstab show multiple objects in top header?
for example, the data showed as :
customer city name city value product name product value
A Paris 1 food N
A London 2 milk T
B London 3 food E
B Paris 4 milk M
C London 6 food W
C Paris 3 milk Q
D London 1 food E
D Paris 2 milk R
i want show these data in crosstab, and customer is the left header, city name and product name are the top header, and city value and product value are measures in the crosstab,
and i want show the data as below:
London Paris food milk
A 2 1 N T
B 3 4 E M
C 6 3 W Q
D 1 2 E R
but actually i got below result in crosstab:
London food London milk Paris food Paris milk
A 2 T 1 N
B 3 E 4 M
C 6 W 3 Q
D 1 E 2 R
anyone can help me on this?
thanks.
Hi,
Did you choose Turn to option change vertical report to cross tab report
Try this one..
Drop the cross tab template in work area then drop the objects as per your requirement. You get the correct result.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
a) Create 2 cross tab adjustment to each other.
b) In both the table take Customer as a column.
c) In first table use City Name dimension in table header and in second table Product name as a table header.
d) Hide the Customer column in the second table via table property. ( Property< Display < Show left Header)
E) Keep the relative Position of both the table zero.
Please take care of the formating and relative position of both the cross tab.
This will be dynamically take the value and will not impact any thing even if data get changed or added in the database.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you see this image?
https://weblogs.sdn.sap.com/weblogs/images/252123862/trick2.JPG
The steps I did to get it were:
1. Insert a crosstab. In the first column put this formula
=[customer]
2. In the blue row cell do not put the city name directly but this formula:
="*London*"
3. Add 3 columns. In each blue cell (header cells) put this formulas: ="Paris", ="food"
, ="*milk*"
4. Now, in the white cells:
In the first column put this formula:
=Max([city_value] Where ([city_name]="London"))
In the second
=Max([city_value] Where ([city_name]="Paris"))
In the third column:
=Max([product value] Where ([product_name]="food"))
In the fourth column:
=Max([product value] Where ([product_name]="milk"))
Sadly this is not dynamic as you can see, but is the only way to achieve what you want to display.
Otherwise better follow the advice by the other posters.
Edited by: PadawanGirl on Mar 2, 2011 5:48 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.