multipel Pivot on Same sheet

[Arvind1977]

I we have same criteria in diff sheets , can it be possible to put values from diff sheets to same criteria in single pivot table please help.


Example like
Sheet 1

A some Value
B some Value
c Some Value

Sheet 2

A some Value
B some Value
c Some Value

Sheet 3

A some Value
B some Value
c Some Value

What I Want is
---- Sheet1 ---- Sheet 2 ---- Sheet3
A--- some vlaue -- Some Value -- Some Value
B--- some vlaue -- Some Value -- Some Value
C--- some vlaue -- Some Value -- Some Value


Please Help if anyone know this

 

[harshab6]

hi,

Loook ta this http://www.datapigtechnologies.com/flashfiles/mcrpivottables.html

in this site the pivot table is applied in same sheet.but this can be also applied to different sheets even a workbook.

 

[Fazza]

Suggest you offer a more specific sample, Arvind.

 

[Arvind1977]

What i am doing now is . first i am making Three Pivots like this

Time Band Total
0600-1000 116990
1000-1800 188705
1800-2400 158540
2400-0600 865
Advertorial
MKT Promo 50960
Non FCT
Grand Total 516060


Sum of Length
Time Band Total
0600-1000 102030
1000-1800 185150
1800-2400 177460
2400-0600 1765
Advertorial
MKT Promo 32055
Non FCT
Grand Total 498460


Sum of Length
Time Band Total
0600-1000 76910
1000-1800 119115
1800-2400 105265
2400-0600 1050
Advertorial
MKT Promo 30725
Non FCT
Grand Total 333065



Then making Report like this

Channel Actual FCT Budget Loss of inventory
SN 516060 982440 -466380
SA 498460 804240 -305780
SM 333065 893160 -560095
Total 1347585 2679840 -1332255

 

[Arvind1977]

please help the link is not that what i want

 

[Fazza]

I can't help, Arvind, based on the data posted to date. I don't understand the requirement.

I suggest the description of the question - with sample data input & output - needs a total re-write from the beginning so that the requirement is clear and simple to understand.

regards

 

[Arvind1977]

sorry is there any way to upload excel file .
or to directly mail it to u

i dont have any website.