Getting only one value dimension for chart.

[berryandcherry6]

Hi ,

I have a Fruits column, where

Dimension: Fruits

FruitsID Fruits

  1             Apple

  2             Banana

3               Mango

4              Organe

In this i need to get only one fruitname to display in dimension.How could i display, or add equation in dimension so it only chooses only required fruits name

Please help me. Any help is appreciated.

[arulsettu · Accepted solution]

if you want to display only one fruit in dimension

you can try in dimension like this

if(match(Fruits,'Apple'),Fruits)

or

in expression

count({<Fruits={'Apple'}>}sales)

[berryandcherry6]

Thanks Arul,

I choose first expresion, as i need to put in Dimension.

Regards