Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Use Transpose()
I think you can use crosstable funtion also!
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
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