98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multi Data Column PivotTables
Multi Data Column PivotTables
Resolved · Urgent Priority · Version 2003
Wed 29 Jul 2009, 15:04Delegate Gareth said...
Gareth has attended:
Dreamweaver 8 Introduction course
Excel Intermediate course
Excel Advanced course
Multi Data Column PivotTables
I have a spreadsheet to which I want a pivot table made.
The columns are A: Bank, B:Amount, C: Exchange Rate, D:GBP, E:USD, F:EUR etc.
Evry cell is populated. I want to be able to filter by bank, amount or exchnager rate, and see all my currency columns going across the table. It won't do it!! I can put the currency columns side by side on the pivottable layout.
Please help!!
Wed 29 Jul 2009, 15:26Trainer Amanda said...
RE: Multi Data Column PivotTables
Hello Gareth
Thank you for your question.
I think by the sounds of things this would have do with where fields are positioned in the pivot table - you might have to make three different tables - one with Bank in Page Fields, one with Amount in Page Fields, and one with Exchange Rate in Page Fields maybe?
Kind regards
Amanda
Wed 29 Jul 2009, 15:48Delegate Gareth said...
RE: Multi Data Column PivotTables
Thanks for your answer Amanda, however, that has gone straigh tover my head. I can see plenty of examples on the web that look exactly like I want. Can you explain in a bit more detail. Essentialy, I want to be able to pivot column A, B or C, and view the corresponding data columns across the rest of the table.
Thu 30 Jul 2009, 10:06Trainer Amanda said...
RE: Multi Data Column PivotTables
Hi Gareth
Perhaps you could send me a link to one of the examples you've seen, this would help.
thanks
Amanda
Thu 30 Jul 2009, 10:09Delegate Gareth said...
RE: Multi Data Column PivotTables
can i email it to you?
Thu 30 Jul 2009, 15:37Trainer Amanda said...
RE: Multi Data Column PivotTables
Hi Gareth
Sorry about the delay in responding. Yes, if you would like to email it through, that's fine. Address is amanda@stl-training.co.uk
Kind regards
Amanda
Thu 30 Jul 2009, 15:39Delegate Gareth said...
RE: Multi Data Column PivotTables
Amanda. I've just managed to fix it myself. Thanks for your assiatcne though.
Thu 30 Jul 2009, 15:48Trainer Amanda said...
RE: Multi Data Column PivotTables
Hi Gareth
Glad to hear you've got a solution :)
Amanda
Thu 6 Aug 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Paste functions box quicklyIf you want to do a formula using the paste functions box press SHIFT + F3. |
