xavier.bonislawski Posted September 6, 2018 Share Posted September 6, 2018 HiI have a crosstab but I do not want all the values (rows) returned by the queryfor exemple SALESState jan Feb TotalTexas 10 5 15California 10 10 20Arizona 5 5 10 25 20 45 And I do not want the datas for California so the crosstab should beState jan Feb TotalTexas 10 5 15Arizona 5 5 10 151025 And the total is also modifiedIs 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now