Jump to content
Changes to the Jaspersoft community edition download ×

crosstab, add filter on rowgroup


xavier.bonislawski

Recommended Posts

Hi

I have a crosstab but I do not want all the values (rows) returned by the query

for exemple SALES

State 

  jan            Feb      Total

Texas        

10            5           

15

California 

10            10         

20

Arizona    

5               5          

10

   25            20          

45

              

And I do not want the datas for California so the crosstab should be

State 

  jan            Feb      Total

Texas        

10            5           

15

Arizona    

5               5          

10

 151025
    
    

And the total is also modified

Is it possible to do that without modifing the SQL Query ? (The name of the state is a field value returned by the query)

 

Regards

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...