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 10 expression. So for every Dimension the pivot table displays 10 rows of data with Amount value.
Now I need to display to display for the same 10 expressions with more columns to the right
for example -
| 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
Any help on the above please?