Help on Pivot tables

[vinayashwitha]

Hi All,

Need help on pivot tables.

I have date in an excel and i have inseted two pivot tables on the same data. Pivot table are in different worksheet in the same file.

Problem i am facing is, when i change the grouping of fields in one pivot table, the same is happening in another pivot table also.

Can you please help me with this.

Thanks in advance.

Regards
Vini

 

[snoopyhr]

<>

 

[RoryA]

You need to ensure the two pivots do not use the same pivot cache. Which version of Excel are you using?

 

[snoopyhr]

ok,let me try again.....

look at this link, good tutorial on this issue

http://www.contextures.com/xlVideos11.html#Group

 

[Marky31mark]

Hello, I need some help with my pivot tables.

I have a table of data that has multiple Sales prices for each sku. I need to pull a summary of our transactions, and let me know what the different sales prices were for each item.

Example below:

<colgroup><col style="mso-width-source:userset;mso-width-alt:3607;width:78pt" width="103"> <col style="width:48pt" width="64" span="7"> </colgroup><tbody>
[TD="class: xl75, width: 103"]Item[/TD]
[TD="class: xl75, width: 64"]Type[/TD]
[TD="class: xl75, width: 64"]Date[/TD]
[TD="class: xl75, width: 64"]Num[/TD]
[TD="class: xl75, width: 64"]Qty[/TD]
[TD="class: xl75, width: 64"]Sales Price[/TD]
[TD="class: xl75, width: 64"]Amount[/TD]
[TD="class: xl75, width: 64"]Balance[/TD]

[TD="class: xl65"]Z215088-13[/TD]
[TD="class: xl65"]Invoice[/TD]
[TD="class: xl66, align: right"]05/09/2018[/TD]
[TD="class: xl65"]23422654[/TD]
[TD="class: xl67, align: right"]1.00[/TD]
[TD="class: xl67, align: right"]20.00[/TD]
[TD="class: xl68, align: right"]20.00[/TD]
[TD="class: xl68, align: right"]20.00[/TD]

[TD="class: xl69"]Z215088-13[/TD]
[TD="class: xl69"]Invoice[/TD]
[TD="class: xl70, align: right"]05/10/2018[/TD]
[TD="class: xl69"]23422989[/TD]
[TD="class: xl71, align: right"]1.00[/TD]
[TD="class: xl71, align: right"]20.00[/TD]
[TD="class: xl72, align: right"]20.00[/TD]
[TD="class: xl72, align: right"]40.00[/TD]

[TD="class: xl65"]Z215088-13[/TD]
[TD="class: xl65"]Invoice[/TD]
[TD="class: xl66, align: right"]05/14/2018[/TD]
[TD="class: xl65"]23423804[/TD]
[TD="class: xl73, align: right"]1.00[/TD]
[TD="class: xl67, align: right"]20.00[/TD]
[TD="class: xl74, align: right"]20.00[/TD]
[TD="class: xl74, align: right"]60.00[/TD]

[TD="class: xl69"]Z215088-13[/TD]
[TD="class: xl69"]Invoice[/TD]
[TD="class: xl70, align: right"]03/30/2018[/TD]
[TD="class: xl69"]23414384[/TD]
[TD="class: xl71, align: right"]2.00[/TD]
[TD="class: xl71, align: right"]18.50[/TD]
[TD="class: xl72, align: right"]37.00[/TD]
[TD="class: xl72, align: right"]37.00[/TD]

</tbody>

I was thinking a pivot table would be the best way to pull back my data. Not sure if anyone has a different suggestion.

I am trying to pull all the different Sales Prices for each Item. Can I pull an place each Sales price in its own column?

Thanks,
Mark