I want to create a monthly summary report using crosstab for three categories.
For example, say I want to view the Total Items Purchased in an year grouped by month. Total Items sold in an year grouped by month. Total Profit or Loss in the year grouped by month.
I've tried to use three crosstabs but they overlap with one another. Is there a workaround or can the crosstab's position be set such that it starts where the previous one ends ?
I've attached the screenshot that shows the overlap.
There is a table at the extreme left. Next to it are the two crosstabs. As can be seen from the first crosstab, the last two months are overridden..