Help! Filters not working with OVER Function

[Nilanjan Saha 2]

Hi All,

I am currently new in Spotfire and trying to understand how the tool works.

I am creating a Tablular report for each Region,Sub-Category I have plotted the Sum(Sales),Sum(Profit) and another calculated column which shows the Maximum Profit.

However when I use a filter, the filter does not populate the calculated field which has a OVER function.

Attached is the dxp file.

Please can anybody help how to use Filters in Over function.Any help is highly appreciated.

[Khushboo Rabadia]

Filters do not work with calculated columns. You can use cross table instead which allows the use of custom expression (that responds to filtering)