How to implement a filter on a calculated column of a cross table

[Tauseef Sheik]

I have a cross table in which I have a calculated column. and when I use filter it doesn't respond. Please help. See the attached screenshot. I've deselected everything from my filter which is flight type yet it doesn't update.

[Khushboo Rabadia]

Check in visualization properties of cross table > Data > Limit data by filterings > Is the default filtering used on the page is checked

If the default filtering is checked for the visualization, check what is the filtering scheme for your Flight Type filter.

Whatever filtering scheme is applied to that flight type filter, the same should be applied to visualization as well in order to have it respond to filters.

[Tauseef Sheik]

Hi Khushboo,

 

Thank you so much it worked. I have one more doubt though. When ever I click my filter my crosstable changes, my calculated column changes perfectly. Now my question is that, is it possible that if I make a selection oin my crosstable my filter also automatically updates