About Pie Chart Dimension

[GaryChin]

Hi All,

The data shown below:

Product	Value
AA	22
BB	23
CC	56
DD	942
EE	133
FF	115
AA	5525
BB	52
CC	452
DD	21
EE	1545
FF	455

I just want to display Sum(AA),Sum(BB),Sum(CC) in a pie chart. How can I filter out the other without filter pane. The dimension is Product and measure is Value.

Thanks

Gary

[Vegar]

Try it like this : Sum({<Product={'AA', 'BB', 'CC'}>} Value) 

[GaryChin]

Dear Vegar,

There only show sum AA value.

Thanks

Gary

[Vegar]

Make sure you got the  spelling of the field values correctly. It's case case sensitive and if the field is a dual then you need to refer to the string part of the dual. 

[GaryChin]

Dear Vegar,

I solved this problem. In the measure Expression I written:

sum({<Product={'AA'}>}Value) & sum({<Product={'BB'}>}Value) & sum({<Product={'CC'}>}Value) 

The pie chart only display that three product.

Thanks

Gary