Detail by Month, adjoining blocks

Emil Amante

So this is my desired output in terms of how the columns are ordered.

By MONTH:

1. Actuals
2. Forecast
3. Variance

I tried seemingly every which way to get this achieved result, and the only way that "almost" works is doing detail by for all 3 blocks, but adding "order" and keep top 3, for all 3 blocks. But ascending in this context, actually means the $ amount.. So the order doesn't work and breaks easily.

Hamza Mesbahi

Hi @Emil Amante ,

Thanks for your question.

May I ask if there's a specific reason you're not using Month by Column? Based on the screenshots you provided, it looks like all three blocks can be broken down by Month, which would make that the most straightforward approach.

Here's a simple example:

Report:

Layout configuration:

Axes settings:

If I've misunderstood the issue, or there's a specific requirement that prevents you from using Month by Column, please let me know.

Hope this helps.

Hamza