Skip to Content
0
Jul 26, 2016 at 11:34 AM

Suppress row in crosstab

30 Views

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

Attachments

1.JPG (82.3 kB)