Thanks, I'll look into the GetPivotData function. As I have more than 30 000 rows I would like a way to automate as much as possible. I understand making two pivot tables and then a third based on the two first and then stacking the account fields will get me close to where I want to be.
//Ola
I wonder if any of you excel ninjas can tell me if it is possible to to have different row fields for different value fields?
Say I have two value fields stacked (Amount & tax), can I have them preceded by different row fields?
Please have a look at the linked worksheet where I try to show...
Hi, Ola from Sweden here, been reading the RSS feed for awhile, thought I should register and join the conversation.
Works as an accountant and the main tools of my trade is Excel and Qlikview.
Hopes to become awesome in excel :)
/Ola