Expression in HOrizontal Way

[pavanthota]

Hi

I have one dimension called A ,it has multiple values and multiple expressions called B. C and D. I want to show the expressions B, C and D values in row wise based on the Dimension A values. Please find the below example.

XYZ, RTY, UVW, PQR,STU is the Dimension A Values. Dimension A should be converrt as column header that we can do through pivot table.but how to convert expressions row wise.

	XYZ	RTY	UVW	PQR	STU
B	100	300	500	700	600
C	20	30	40	50	78
D	10%	20%	60%	89%	78%

Can you please help me  anyone

[swuehl · Accepted solution]

Use a straight table with your one dimension and three expressions and enable option 'Horizontal' on presentationt tab.

[pavanthota]

Hi Swuehi,

Thank you very much for your quick reply

[pavanthota]

Hi Swuehi,

One more help i needed from you i need to show row total at the right hand side  as a total column can you please help me on that.

Thanks,

Pavan

[swuehl]

You should see a total column when you using a total mode with totals for your expressions.

Then select option 'totals on last row' on presentation tab.

[pavanthota]

Hi Swuehi,

I tried the option which you mentioned above unfortunately its not working

[pavanthota]

Hi Swuehi,

Thanks for Quick reply I am sorry about previous reply option is working now

[swuehl]

Could you post a small sample QVW?

Also, it's not working is not a precise issue description.

Does this mean you don't get totals at all or you are not able to move the total column to the right?