crosstab, add filter on rowgroup

0

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

  15 10 25
       
       

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

xavier.bonislawski's picture
Joined: Feb 17 2017 - 1:00pm
Last seen: 1 week 6 days ago

0 Answers:

No answers yet
Feedback
randomness