Helly everyone
I have one sheet with the pivot table, containing several row dimensions and one column dimension, which i have extracted from a cube. My problem is that i want to copy the data to "Load Demo", but when i try to use the getpivotdata and copy it into the Load sheet i have to manually enter each cell and click on the specific cell in the Data Demo sheet, which is really cumbersome work. Is there no way to drag the entire columns? I really don't know where to start since the formula that Excel generate for the Getpivotdata sounds like:
=GETPIVOTDATA("[Measures].[Value Local]";'Data Demo'!$A$6;"[Account].[Account ID]";"[Account].[Account ID].&[100100]";"[Customer].[Customer ID]";"[Customer].[Customer ID].&[WSA]";"[Product].[Product ID]";"[Product].[Product ID].&[PA]";"[Calendar].[Y -Q - M]";"[Calendar].[Y -Q - M].[Calendar Month].&[201402]";"[Account].[Account external]";"[Account].[Account external].[Account ID Account External Niv7].&[100100]";"[Customer].[Customer]";"[Customer].[Customer].[Customer ID Customer Niv3].&[WSA]";"[Product].[Product]";"[Product].[Product].[Product ID Product Niv3].&[PA]")
Please check the excel file
Hope someone can help
Bookmarks