Display straight table columns in Horizontal

[Anonymous]

Hi All,

It's possible to display straight table columns in horizontal. I tried Presentation tab but didn't help. I want to display in Table B view. Please see below. Any help greatly appreciated!

Table A

Company	SUM_1 (MTD)	SUM_1(YTD)	SUM_1(LTD)	SUM_2 (MTD)	SUM_2(YTD)	SUM_2(LTD)
ABC	1	2	3	7	8	9

Table B

Company	MTD	YTD	LTD
ABC - SUM_1	1	2	3
ABC - SUM_2	7	8	9

Many Thanks,

Frank

[marcus_sommer]

Change the chart-type to pivot-table and you could drag dimensions and expression like you want.

- Marcus

[Anonymous]

Thanks Marcus.  It works for MTD once I drag it as you said with Pivot table.

What I have is 3 SUM expressions with same Dimension for MTD, YTD, and LTD calculations.  I want MTD, YTD, and LTD lables as my header and this dimension as the row.

Company		MTD	YTD	LTD
ABC	P&L	1	4	7
ABC	Expenses	2	5	8
ABC	FEES	3	6	9

[marcus_sommer]

If you used MTD/YTD ... as a real dimension - maybe created withThe As-Of Table - you wouldn't need anything more. If not you need to create a calculated dimension, maybe per valuelist('MTD', 'YTD', 'LYTD') and which also must be integrated into your expressions, like:

pick(match(valuelist('MTD', 'YTD', 'LYTD'), 'MTD', 'YTD', 'LYTD'),

     sum({ < FlagMTD = {1}>} [P&L]),

     sum({ < FlagYTD = {1}>} [P&L]),

     sum({ < FlagLYTD = {1}>} [P&L]))

- Marcus

[Anonymous]

Thanks Marcus. It's helpful to know.