Modify your query so that it includes the date and percentage data probably with a union. I believe it matches yours, but am inserting a picture of it here for review. As the crosstab generation is dynamic, it would be difficult near impossible to try combine the already completed crosstabs, and both rows and columsn may differ between the two. For instance, if you do this:.
Show both row and column totals, to appear at the right and bottom of the report respectively. Thanks again! The description of that parameter will give a little more detail. Typically, no one thinks to specify that nulls should be excluded. There are a number of ways to address this. Not sure if this will help you but I had the same issue.
From the Data pane, drag Category to the Rows shelf and place it to the right of State. Compile a cross tab report that displays the order value by customer, by quarter.
Returns the minimum of an expression across all records or the minimum of two expressions for each record. Marc, Oh cool.
The data type of the calculated fields in the cross tab grid can be specified by the CalcFieldType parameter. SQL Fiddle. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible. The ColFieldOrder parameter should hold the name of this ordering field.
How I to make this from below to work: Ben Nadel Oct 3, 2007 at 3: If you only want something to be done if A and B are different, either use one of the correct expressions shown above and put a dummy statement in the then clause starting at 1. In the example shown there is a sequence column. Ivan Mar 25, 2009 at 7: The debug gives me this:. But don't get the bright idea of inverting the expression and using it as an inequality test:.
Post the source code for your solution in the comments to this article, or send it to Tony at editor simple-talk.
Coalesce will fold nulls into a default: