Hallo all I need help I study last topic with this problem but withouth result.
I have cross tab:
cetegory turnover
S 100
M 200
L 300
xxx -10
Total 590
It is possible suppress row "XXX" ? like this (result)
cetegory turnover
S 100
M 200
L 300
Total 600
input to filter is not possible because category is formula fx:
S M and L is define formula fx: name fx is: "category" this is input to area cross tab rows
FX:category
if Sum ({@turnover}, {@customer}) >0 and Sum ({@turnover}, {@customer}) <= 500 then "S" else
if Sum ({@turnover}, {@customer}) >= 501 and Sum ({@turnover}, {@customer}) <= 1000 then "M" else
if Sum ({@turnover}, {@customer}) >= 1001 then "L" else "xxx"
thanks marek