Straight Table

[bharatkishore]

Hi All,

I have a straight table and have 10 dimensions and 2 expressions.

Now whenever i select any dimension in the straight table chart it will filter and i when ever i select the filtered one it will un-filter.

My requirement is, is there anyway to highlight(with colour) the selected field or dimension in straight table so that i can know which dimension got filtered in case if i forget what is filtered. So that i can un-filter.

Please let me know if we can achieve this.

Thanks,

Bharat

[jujucts]

Hi Bharat

once a field is selected you can check it thru current selection menu or current selection object if you set one

but I would say a straight table would may not be the best way to show too many information

think to a pivot table instead or think about cycle/hierarchical groups and even best would be to keep only useful dimension

enjoy  it

juju

[bharatkishore]

Thanks Christian. But my requirement is with straight table it-self.. I just want to know is there any way can we achieve this..

[oseimuduame]

can you be specific please?

[Colin-Albert]

The field that is being filtered will show a green dot (beacon) in the column header.

[bharatkishore]

I have a straight table where the image is

:

Now when i select 2 in day of year it will filter as below image:

Is there any way to highlight the background with colour for example say  that now i filtered  day of year dimension so it should highlight with some colour.

N when i un-filter the colour should be .normal.

Please let me know if you require anything more.

Thanks,

Bharat

[d_prashanthredd · Accepted solution]

Hi Bharat,

if(GetSelectedCount(FieldName) >0, Red()

)

I think, you need to write for each filed/dimension.

[sonkumamon]

Hi Bharat,

You can also try to write in each dimension background color expression (Click + near the dimension name)

=If( GetCurrenField() = [Dimension/Field name], Blue())

You can also use Prashanth expression.

[bharatkishore]

Thanks Prashanth...

[bharatkishore]

Thanks Uri