Hi Pauline,

Could you hide the unnecessary columns and then re-extract the data source?

Thanks,

Mavis

Hi Pauline,

Yes, so for this particular crosstab you can use one data source with the 4 fields, whereas with the other views you can bring in a new data source (blending) and then build your other views using this other data source.

Thanks,

Mavis

One more option for you, other than specified already

You can convert all other measures into dimension. This way they will not appear in 'Measure name' field. But you will be able to use them as measure in other sheet.

Hey @PAULINE TISSEYRE

This can be achived using parameter

You create a parameter with all possible values and 1 extra value as All

Create a caluclated culumn based on parameter values

E.g.

IF Parameter = 'Reg' then [Reg]

Else if Parameter = 'Daily Rev.' Then [Daily Rev.]

Else All

End

Use this new calc in your report to get the desired result, if you post the workbook I can quickly update it as per your req.

Hope this helps

S