Table layout

[#1]

Dear all,

I've this table:

Customer     Year     Month     Group     Turnover         

A                 2012     1               G1          1500

A                 2012     1               G2          1000

A                 2012     1               G3          500

B                 2012     1               G1          200

B                 2012     1               G3          400

I would like to produce the following layout:

Customer	Year	Month	Turnover.G1	Turnover G2	Turnover G3
A	2012	1	1500	1000	500

B              2012 1          200               -                 400

but I don't know how to do it

Help please

Thanks in advance 

[swuehl · Accepted solution]

Create a pivot table chart with dimensions Customer, Year and Month and Group

and expression:

=sum(Turnover)

Drag Group dimension to the top and if you want change the dimension Group to a calculated dimension:

='Turnover '&Group

Hope this helps,

Stefan

[#3]

Use Transpose()

[#4]

I think you can use crosstable funtion also!

[#5]

Thanks again, problem solved. Just one thing: is it possible to calculate the sub-totale labels?

for instance, at the end of group G1, I'm using a simple "total group". I would like "total group G1".

I tried by the & operator, but nothig happens. Do you have a trick ?

Anyway thanks for your support

Stefan

[#6]

Thanks, but unfortunatly I'm a beginner and I don't know to to use it and in which cases.

Do you have an example ? I'm working with the personal edition.

Thanks in advance