I - GETPIVOTDATA and why you should too! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Craig
Wow - I never knew I could do this! I have a formula that calculates an average for a weekly report, but I use the source data to calculate it. The problem is that the worksheet gets saved and edited by someone else, who then removes the source worksheet so that some people cannot see some of the data, leaving only the worksheets that contain the pivot tables; however, this breaks the formula, so I always have to repaste the output value back into the cell to remove the formula prior sharing the worksheet with that person.
With what you just shared, I think I can revise the formula so that this is no longer a worry. Thank you so much!
reply
Wow - I never knew I could do this! I have a formula that calculates an average for a weekly report, but I use the source data to calculate it. The problem is that the worksheet gets saved and edited by someone else, who then removes the source worksheet so that some people cannot see some of the data, leaving only the worksheets that contain the pivot tables; however, this breaks the formula, so I always have to repaste the output value back into the cell to remove the formula prior sharing the worksheet with that person.
With what you just shared, I think I can revise the formula so that this is no longer a worry. Thank you so much!
reply
Maddy
Hi mam I have a doubt
Let's say I have 2 pivot tables and iam using getpivotdata to divide a number from first pivot table to the second. After getting the values, how to sort them in descending order. Because I couldn't able to order the numbers. Kindly help
reply
Hi mam I have a doubt
Let's say I have 2 pivot tables and iam using getpivotdata to divide a number from first pivot table to the second. After getting the values, how to sort them in descending order. Because I couldn't able to order the numbers. Kindly help
reply
tiong
great video! I hope that you can point out the advantages/disadvantages of GETPIVOTDATA vs calculated fields, apart of they are being or not being the part of the pivot table. Is there anything where calculated field can or cannot do where GETPIVOTDATA can?
reply
great video! I hope that you can point out the advantages/disadvantages of GETPIVOTDATA vs calculated fields, apart of they are being or not being the part of the pivot table. Is there anything where calculated field can or cannot do where GETPIVOTDATA can?
reply
Omar
Whenever I'm trying to reference the cell to a total cell in the PivotTable, it's not turning me a Getpivotdata like in your case automatically! Is there another workround to use the function?
reply
Whenever I'm trying to reference the cell to a total cell in the PivotTable, it's not turning me a Getpivotdata like in your case automatically! Is there another workround to use the function?
reply
Holly
Brilliant video, thank you! I'm still getting used to pivot tables- is there a difference between using the getpivotdata function and calculated fields please?
reply
Brilliant video, thank you! I'm still getting used to pivot tables- is there a difference between using the getpivotdata function and calculated fields please?
reply
Enny
I wish you had shown us more examples of how to make the function dynamic. It worked for this example but I ran into difficulties when I had subtotals.
reply
I wish you had shown us more examples of how to make the function dynamic. It worked for this example but I ran into difficulties when I had subtotals.
reply
Villiam
Excellent vid - thank you. I especially liked the data validation idea as a space-saving alternative to slicers (much as I think they're great...)
reply
Excellent vid - thank you. I especially liked the data validation idea as a space-saving alternative to slicers (much as I think they're great...)
reply
Wayne
Hi Mynda. Thanks for demystifying GETPIVOTDATA! Very helpful understanding how to make it dynamic. Thanks for sharing :)) Thumbs up!!
reply
Hi Mynda. Thanks for demystifying GETPIVOTDATA! Very helpful understanding how to make it dynamic. Thanks for sharing :)) Thumbs up!!
reply
Darwin
Hi I was trying to make my pivot dynamic but my pivot are in measures data from the data model and it always shows an error #ref
reply
Hi I was trying to make my pivot dynamic but my pivot are in measures data from the data model and it always shows an error #ref
reply
Sandip
How many extra rows and columns that we can add to excel spreadsheet ? Or, is it limited to 10,48,576 rows and 16,384 columns ?
reply
How many extra rows and columns that we can add to excel spreadsheet ? Or, is it limited to 10,48,576 rows and 16,384 columns ?
reply
Add a review, comment
Other channel videos
4:14
