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.
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
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.
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.