Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
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?
Thanks I will try to do sample