I have a large crosstab which I have managed to get working quite well including extra columns. To be fair, I'm quite impressed how well the crosstab accommodated the complexity and calculations including the calculations for the row totals.
The problem is that due to the number of columns and rows scrolling becomes an issue. Scrolling right you lose the label column so not sure which row you are viewing - in my case the branch name. Scrolling down you lose the column headers so you don't know which pivot you are looking at.
Any ideas or alternatives? Every where I turn I run into problems.
Please sign in to leave a comment.