Split Pie by Columns

guptaankitcse · July 14, 2011 2:16AM

Hi,

Is there any way I can split the pie on the basis of columns. For example, my column names are X, Y, Z etc. and the values under these columns are figures for various heads (rows). I want to show the total figures split by these columns. Is this possible? If yes, how? Any clues are appreciated.

Thanks,
Ankit

steve · July 14, 2011 4:20AM

You mean this?

X Y Z
1 2 3
should show a pie with 3 segments X, Y and Z, of size 1, 2, and 3?

You should transform your data using Data > Operations > De-pivot (I'm assuming you're using Omniscope 2.6.
This will yield:

Field Value
X 1
Y 2
Z 3

Be aware the transformation will be permanent.

guptaankitcse · July 14, 2011 4:29AM

Thanks for the prompt reply Steve !!
The problem is that I have other columns too, apart from these columns which I do not want to transform.
My exact requirement to be able to do this kind of pie will need my data to be transformed as below

Before -
W X Y Z
1 2 3 4

After -
W K Q
1 X 2
1 Y 3
1 Z 4

Thanks,
Ankit

steve · July 14, 2011 5:24AM

De-Pivot will do this.

guptaankitcse · July 14, 2011 5:36AM

Thanks Steve. It works !!!

Welcome!

Categories

Ideas Parade

Tagged