Hi All,
I've created a crosstab based on relational data using dimensional functions using the technique suggested by Nimrod Avissar in this post (http://www.cognoise.com/index.php?topic=23391.0 (http://www.cognoise.com/index.php?topic=23391.0))
For the actual results I'm getting - the cross tab is displaying the correct information and I have a crosstab layout as per below.
| | Current | Previous | Variance | Show |
| 000001 Person1 Net Total | 1,806.44 | 1,719.12 | 87.32 | 1 |
| 000002 Person2 Net Total | 1,561.72 | 1,561.72 | 0 | 0 |
| 000003 Person3 Net Total | 1,823.85 | 1,753.35 | 70.5 | 1 |
| 000004 Person4 Net Total | 1,644.13 | 1,644.13 | 0 | 0 |
What I am now trying to achieve is where my column "Show" is 0, hide the row. The logic used to calculate "Show" is based on if the variance is +- 1 and if the parameter for "ShowVariance" is "Yes". The data displayed in the "Show" column is correct based on the inputs. How would you go about filtering out the "Show" records that = 0? I've tried doing just a simple filter where [Show] = 1 (but this still returns everything) as well as conditional filtering in the report layout. I'm at a bit of a loss as to what I else I could try.
Does anyone have any suggestions? Any thoughts will be greatly appreciated.