Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try it like this : Sum({<Product={'AA', 'BB', 'CC'}>} Value)
Dear Vegar,
There only show sum AA value.
Thanks
Gary
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.
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