Skip to Content

Transposing Crosstab in SAP business Object Design Studio

This is my crosstab :

ColumnA ColumnB
    X   D
    Y   E
    Z   F

I want it to be converted to :

ColumnA X   Y   Z
ColumnB D   E   F

I checked all the properties and checked for CSS but did not find anything on this topic!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 04 at 01:48 PM

    Hey Sarthak,

    you can not change the Crosstab, you have to change the Datasource.

    Regards,
    Chris

    Add comment
    10|10000 characters needed characters exceeded

    • It will convert the Dimension to Columns, but what about measure ?

      it is still displayed as column on top instead of rows, how can we display Measure name in Rows?

  • May 07 at 06:43 AM

    Hi,

    if you are using bex query for design then it is better to do at bex query level. Then you can use button to show /hide one query

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded