How to display data in the mentioned format in Pivot Table?

anilkumarmishra — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to display data in the mentioned format in Pivot Table?

pooja_prabhu_n — Thu, 14 Jun 2018 07:18:05 GMT

Hi Anil,

You can try something like below