filter

hi

i have to use = iif((Fields!Market.Value/SUM(Fields!Market.Value,"dataset1")) * 100 )= 0.0

in my filter,

it gives me error like aggregate function cannot use in a filter.

is there any other way ,i can use this expression in filter 

Additional que, there is group in tablix,

if i put this filter in group ,its works fine,but thw whole group is invisible.

i just want one row to be invisible.

how to do that

It is hard to tell from what you have posted, but I would probably go back to the dataset query and use a windowing function (OVER) to get the aggregation you need at the row level.

Something like SUM(Market) OVER(PARTITION BY Market) AS MarketTotal

its fine.I got solve it.

Thanks for your concern