Straight table with Month in column

[danosoft]

Hi i need to put a table like this, with in column my month (field MESE_COMPETENZA)

and in my row my field AGENZIA

tha value is CONSUMO_SMC

How can i do that?

Thanks

[zhadrakas · Accepted solution]

try like that:

- create a diagram > pivot table

- add 2 dimensions AGENZIA & MESE_COMPETENZA

- add expression sum(CONSUMO_SMC)

- drag and drop the month dimension to the top

- i think you want to tick the checkbox  "Always Fully Expanded" on presentation tab