crosstab, add filter on rowgroup

[xavier.bonislawski]

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