Several measurements in single Crosstab

[ArnaudStephanHTH]

Hello everyone,

I have a list of measurements in a data source :



And I would like to show them in a crosstab, having one line by type of measurement. As you can see, all measurements are duplicated. There is MEASUREMENT and MEASUREMENT_IMRP.

The hierarchy of the crosstab would be like that :

                                           Lib Long Division
                              Centre de Coût     |        Centre de Coût
                             Normal | Impr      ||       Normal | Impr
Measurement 1
Measurement 2
Measurement 3

And the result would look like that :




The problem is that if I try to put several measurements in the crosstab I get one column per measurement, and I can't put them line by line.



And if I drag the measurements to the lines, then I lose the Normal/Impr distinction in the columns that I want :



I have seen reports (that I don't have access to anymore) where it had been made possible, so I'm sure there is a way of doing that. Any leads ?

[ArnaudStephanHTH]

I found a way !

The data was coming from a JOIN, to get columns with the normal measurements and columns with the IMPR measurements. Instead of a join I used an union, and added a data item to track the source of each line.