 | |
strange measures order in excel table
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
strange measures order in excel table -
08-25-2006
, 06:57 AM
#2
| |||
| |||
|
|
hi to all, i have a cube with dimensions and measures as well. when i put the first dimension on rows, the second dimension on columns and a measure in the data area, the layout i get is the following one: dim2 dim1 measure1 However, when i add a second measure i'd like it would place at the right of the first measure, having more measures on the same row: dim2 dim1 measure1 measure2 but excel has a strange behaviour: it places the second measure under the first, having this situation: dim2 measure1 dim1 measure2 how can i get the wanted arrangement for measures after the first one? Thanks in advance for the help! Gabriele! |
#3
| |||
| |||
|
|
move the data region to the column "Gabriele!" wrote: hi to all, i have a cube with dimensions and measures as well. when i put the first dimension on rows, the second dimension on columns and a measure in the data area, the layout i get is the following one: dim2 dim1 measure1 However, when i add a second measure i'd like it would place at the right of the first measure, having more measures on the same row: dim2 dim1 measure1 measure2 but excel has a strange behaviour: it places the second measure under the first, having this situation: dim2 measure1 dim1 measure2 how can i get the wanted arrangement for measures after the first one? Thanks in advance for the help! Gabriele! |
#4
| |||
| |||
|
|
hi! thank you very much for your answer, but I can't find the commands to move the data region to the column...can you explain me how can i do it? Thank you for your help! Gabriele yongli ha scritto: move the data region to the column "Gabriele!" wrote: hi to all, i have a cube with dimensions and measures as well. when i put the first dimension on rows, the second dimension on columns and a measure in the data area, the layout i get is the following one: dim2 dim1 measure1 However, when i add a second measure i'd like it would place at the right of the first measure, having more measures on the same row: dim2 dim1 measure1 measure2 but excel has a strange behaviour: it places the second measure under the first, having this situation: dim2 measure1 dim1 measure2 how can i get the wanted arrangement for measures after the first one? Thanks in advance for the help! Gabriele! |
#5
| |||
| |||
|
|
You can drag the data region to the column. "Gabriele!" wrote: hi! thank you very much for your answer, but I can't find the commands to move the data region to the column...can you explain me how can i do it? Thank you for your help! Gabriele yongli ha scritto: move the data region to the column "Gabriele!" wrote: hi to all, i have a cube with dimensions and measures as well. when i put the first dimension on rows, the second dimension on columns and a measure in the data area, the layout i get is the following one: dim2 dim1 measure1 However, when i add a second measure i'd like it would place at the right of the first measure, having more measures on the same row: dim2 dim1 measure1 measure2 but excel has a strange behaviour: it places the second measure under the first, having this situation: dim2 measure1 dim1 measure2 how can i get the wanted arrangement for measures after the first one? Thanks in advance for the help! Gabriele! |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.