Displaying multiple columns in a Pivot table

[#1]

Hi - I need help in displaying multiple columns in a Pivot table

Basically I have 2 fields in Dimension and 5 expression. So for every Dimension the pivot table displays 5 rows of data with Amount value.

Now I need to display to display for the same 5 expressions with more columns to the right

Bascially I want to get something like the below -

			Amount	Avg Amt	Amt Variance	Amt Yearly	Amt month
Dim1	Dim2	Expr Field 1	X
		Expr Field 2	X		X
		Expr Field 3	X	X		X
		Expr Field 4	X				X
		Expr Field 5	X
	Dim2	Expr Field 1	X
		Expr Field 2	X		X
		Expr Field 3	X	X		X
		Expr Field 4	X				X
		Expr Field 5	X

Appreciate your help

[#2]

Hi Dimple,

   In Pivot Table you can't add dimensions on Right side after expressions. Dimensions always it comes on Left and Expressions will comes on Right. In straight table you can do this,can make arrange on any format but you won't get the Grouping of data and subtotals.

[sundarakumar]

Can you please explain on what columns that you want to add?

i.e the columns that you wish to add betw dim and exp in pivot table.

-Sundar

[#4]

Hi,

Now I need to display to display for the same 5 expressions with more columns to the right

Do you want to add more dimensions or more expressions?

Can you elaborate a little or add a sample app if possible?

[#5]

Thanks I will try to do sample