Count() function does not work when filtered by data.

[Abhishek Patil]

Hi All.

I am new for spotfire is there any way can i create Measures in spotfire bcz calculated coloum will not dynmic it all custom expression and I have input data [year],[pwk_w_sal] so i just want group by year and I've created a calculated column called TOTAL=sum([pwk_w_sal])/count([year]).But count() is taking the entire table number of rows count of year. I need yearwise calculation total. Please suggest me with a few solutions.

Thank you

[Khushboo Rabadia]

Calculated columns will not respond to filters. So if you want the expression in visualization to respond to filters, create custom expression in visualization instead of calculated columns.