Cross table SAP Analytics Cloud

[Former Member]

Hello,

I would like create a cross table with two measures like report Web Intelligence, actually in SAP Analytics Cloud when I create my cross table my two measures are added in the table but I don't want see that.

I have join two pictures, 1st is cross table in Web Intelligence, 2nd is cross table in SAP Analytics Cloud only 1 measures can be added in table but I need to make it in Filters and I would like add "Quantity Sold" like in 1st picture in Web Intelligence

You think it's possible to realise that ?

Thank's you in advance.

MV

webi-crosstable.png sac-crosstable.png

[julian_jimenez · Accepted solution]

Hi Mickael,

If you add to columns Year and the measures that you want, leaving Year on top, it will break it as you want.

Tables will always select all your measures (Account) but you can filter the members that you want to display.

Regards,

Julian

[Former Member · Accepted solution]

Thanks for your answer Julian.

Regards.

Mickael