hii have to use = iif((Fields!Market.Value/SUM(Fields!Market.Value,"dataset1")) * 100 )= 0.0in 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