Skip to Content

Suppress row in crosstab

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

1.JPG (82.3 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 26, 2016 at 11:36 AM

    Hi Marek,

    Go in Report -- Selection Formulas-- Record and give below condition

    {@category} <> 'xxx' // category formula not equal to xxx

    Thanks,

    Sastry

    Add a comment
    10|10000 characters needed characters exceeded

    • Unfortunately it is not possible because it must be evaluated later. (attach)

      And it does not offered to choose when I click on Category, then click on 'Group Options'-- common --Select ' Specified Order' and select only S , M, L , again, same thing will happen, How you wrote -it is not visible because it is a summary at group level....

      The first option does not work Also.

      It is hard some other possibilities you do not have?

      thanks Sastry

      4.JPG (89.9 kB)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.