Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All I have two dimensions ZONE & VARIETY and 4 expressions (EXP1,EXP2,EXP3,EXP4) for each Zones.
I want to display Variety & Zone wise sum of all expressions in the below format...
EAST WEST NORTH SOUTH
EXP1 EXP2 EXP3 EXP4 EXP1 EXP2 EXP3 EXP4 EXP1 EXP2 EXP3 EXP4 EXP1 EXP2 EXP3 EXP4
Variey
TOTAL EXP1 EXP2 EXP3 EXP4 EXP1 EXP2 EXP3 EXP4 EXP1 EXP2 EXP3 EXP4 EXP1 EXP2 EXP3 EXP4
but I am not able to display the data in above mentioned format.
I am only able to display in the below mentioned format....................
Variety Zone EXP1 EXP2 EXP3 EXP4
V1 EAST
V1 WEST
V1 NORTH
V1 SOUTH
TOTAL EXP1 EXP2 EXP3 EXP4
Note : V1 is the name of Variety which exist in all Zones.
Please help me to display data in the above mentioned format in Pivot Table.
Hi Anil,
You can try something like below