Combine multiple fields into a dimension

[flygstolen_fred]

Hi,

I have a flat quantified table that I want to use a couple of fields to create a piechart.

OrderID	NumberOfProductX	NumberOfProductY	NumberOfProductZ
1232	5	3	0
2342	1	0	2

I want to create a piechart with dimension showing  X, Y & Z and how the percentage distribution between them.

X = 54,5%
Y = 27,2%
Z = 18,1% 

Any help is appreciated!

[treysmithdev · Accepted solution]

This worked for me:

Dim: 

=ValueList('X','Y','Z')

Msr: 

Pick(Match(ValueList('X','Y','Z'),'X','Y','Z'),
	Sum(NumberOfProductX),
    Sum(NumberOfProductY),
    Sum(NumberOfProductZ))

I would suggest combining the fields in the following way though for performance reasons. You can utilize the CROSSTABLE load for this.

Order ID	Product	Qty
1232	X	5
1232	Y	3
1232	Z	0
2342	X	1
2342	Y	0
2342	Z	2

[flygstolen_fred]

Works very good, thanks!