Thank you for your reply. I knew I should of included more details in my original post, Sorry about that.
The goal is to display each month in one column along with calculated measures, than the flowing month with the same calculated measures.(does that make sense?)
Bellow is the example of what I am trying to accomplish in crosstab view:
1 of 1 people found this helpful
Are you sure you want it displayed like that? I feel like it would be hard to know which month's measures you're looking at if everything is grouped together like that.
I think it would be easier to navigate if you either:
1) Put Months on the column shelf so that each month is across the top, and then underneath that you can put your measure names on columns and measure values on your marks card to show Measure 1, 2, 3, and 4 per month;
2) Put your months on the row shelf (so that they'd all be in one column) and have measure names on columns and measure values on your marks.
Either of those would make it much easier to read.
If you really want it laid out the way you have it above, the only way I can think of doing that would be to create separate workbooks for each month, and then float them next to each other on a dashboard to give you that view.