Jump to content
Changes to the Jaspersoft community edition download ×

Excluding One Cell in a Crosstab Total


rlesmoore

Recommended Posts

I have a crosstab with the same items for rows and columns and a total column for each row. I would like to add a new total column (Total2) that is the same as the previous total column (Total)  except to exclude the count where the row item equals the column item. I can't figure out the Expression to use for this calculation. Any ideas are appreciated?

For example

      a   b   c   d   e  Total  Total2

a   1   2    3  4   5     15     14

b   1   2    3  4   5     15     13

c   1   2    3  4   5     15     12

d   1   2    3  4   5     15     11

e   1   2    3  4   5     15     10

 

 

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...