Always show an element of a dimension

[Anonymous]

Hello,

I would like to make for example segment 5 to always show despite of the segment chosen

¿It is possible?

Thank you

Segment	Revenue
SEGMENT 1	5.645
SEGMENT 2	5.297
SEGMENT 3	30.866
SEGMENT 4	13.599
SEGMENT 5	105.624
SEGMENT 6	19.275
SEGMENT 7	2.202
SEGMENT 8	435.346
SEGMENT 9	45.782

[Anonymous]

maybe make your expression

if(Segement='Segment 5',sum({1}Revenue),sum(Revenue))

[swuehl]

You can use set analysis for this, something like

=Sum({<Segment += {'SEGMENT 5'}>} Revenue)