multipel Pivot on Same sheet

Arvind1977

Board Regular
Joined
Jul 21, 2006
Messages
108
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
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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
 
Upvote 0
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
 
Upvote 0
sorry is there any way to upload excel file .
or to directly mail it to u

i dont have any website.
 
Upvote 0

Forum statistics

Threads
1,224,585
Messages
6,179,697
Members
452,938
Latest member
babeneker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top