pivotdata

I want to use the GET PIVOTDATA function to reference data fromwithin a Pivotable. When I enter: =GETPIVOTDATA("Amount",'2019'!$R$4,"Fund","1100","Orgn","2002","Acct","5815"),I get the result of $15,589.15 I want the function to be dynamic and retrieve the informationdisplayed in the Acct...

Hi, been a while since last time... Right now I have a large amount of calculations that produce a range (results) of outcome on the spreadsheet (calc). A single input change all the outcome. I have a macro that loop through all the input (1...1000), copy results and then transpose and paste...

Hello, I need assistance, please! I have an excel document that has multiple worksheets. On one of the worksheets, I have multiple pivot tables that are manually created, based on the data being used. The primary use for this document is to take a "Big Data" file and provide the "customer"...

Hi Everyone, I have created a pivot table from two different tables using power query. Now i am looking for a look up formula which can get the data from the pivot table. Please find attached the picture of my Pivot Table for your reference. The formula looks like this...

Hi there, Guys, I have this work assisgnment where I have to extract data from pivot and display in combined fashion (below). I can extract data and display using getpivot function but what if I want to Join A6 together and then display the result? I also tried circular formulla but it doesn't...