You are purely awesome and saviour in time of need...i always thank God for directing me to your channel
@MyOnlineTrainingHub3 жыл бұрын
Great to know you find my videos helpful, Peter :-)
@psykco2 жыл бұрын
OMG!!! I've been using calculated fields without knowing or learning about calculated items for so long. You've saved years of hard work for me!!! Thank you!!!
@MyOnlineTrainingHub2 жыл бұрын
So pleased I could help 😊
@vijaysahal45562 жыл бұрын
Hi
@cookingfun62455 жыл бұрын
this is the best Pivot Table video on KZbin. What you taught here took me 18 months to teach myself. I wish I would have found this in 2016 2017
@MyOnlineTrainingHub5 жыл бұрын
Thank you! It's great to know the video will be helpful to others :-)
@grahammasters30953 жыл бұрын
Your explanation of the difference between Calculated Field vs Calculated Item was very insightful. Thank you
@MyOnlineTrainingHub3 жыл бұрын
Great to hear, Graham!
@TheSkp030619763 жыл бұрын
Excellent presented in very simple way to understand.
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it, Santosh!
@johansanjaya38913 ай бұрын
wow, what im looking for is in this 9 years ago video. this explanation makes me understand function of calculated things in pivot. i have hard time searching how to calculate difference values between 2 column in pivot. really appreciate that. thanks
@MyOnlineTrainingHub3 ай бұрын
Glad it was helpful!
@hasanismayilov25223 жыл бұрын
Best Excel tutor I have ever seen, great work Mynda, Thank's alot
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much, Hasan!
@martysammon81372 жыл бұрын
You are an excellent teacher Mynda
@MyOnlineTrainingHub2 жыл бұрын
Thanks so much, Marty!
@davidblumberg55439 жыл бұрын
Myanda It is obvious you know excel, but that you explain it so well is what makes taking the time to listen. You are the best. David
@MyOnlineTrainingHub9 жыл бұрын
David Blumberg Aw, thanks :-)
@nsanch01813 жыл бұрын
Thank you Mynda for the example of calculated items. I would love to see more on the calculated fields and items. That was also a neat way to format the % of the "% Renewals". Great video!
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it :-)
@barbiefashion18592 жыл бұрын
Thanks Myndy for the great video. Really helped me work on an assignment with ease.
@MyOnlineTrainingHub2 жыл бұрын
Glad I could help 😊
@simoncarr47242 жыл бұрын
thanks for clear, well explained tutorial!
@MyOnlineTrainingHub2 жыл бұрын
Glad it was helpful!
@AweEmperorofChickenKilling2 жыл бұрын
I could see calculated items coming in very handy on some spread sheets i'm working on now that i know they exist
@MyOnlineTrainingHub2 жыл бұрын
Glad to hear that!
@skywatcher6513 жыл бұрын
Thank you. Learning so much from you
@MyOnlineTrainingHub3 жыл бұрын
Glad it was helpful 😊
@ndamaze2 жыл бұрын
You teach me a lot. Thank you.
@MyOnlineTrainingHub2 жыл бұрын
My pleasure 😊
@lawrenceliew58122 жыл бұрын
this video was made in 2015, until today 7 years later it still benefited person like me. Thanks!
@MyOnlineTrainingHub2 жыл бұрын
Awesome to hear that, Lawrence!
@ScottMoran0012 жыл бұрын
Very helpful, thank you!
@MyOnlineTrainingHub2 жыл бұрын
Glad it was helpful!
@maryannfitzharris38373 жыл бұрын
Very helpful to me. Thank you!
@MyOnlineTrainingHub3 жыл бұрын
So glad to hear that, Mary Ann!
@ankursharma61574 жыл бұрын
Thank You, Mynda! + It is really commendable of You to respond to All Comments. Praiseworthy!
@MyOnlineTrainingHub4 жыл бұрын
You're welcome, Ankur! I think if you've taken the time to post a comment then it's only polite to respond :-)
@jruck423 жыл бұрын
THANK YOU! Finally figured out how to make a "difference" column when pivoting one field!!!
@MyOnlineTrainingHub3 жыл бұрын
Glad it helped, Jamie!
@leobottari81472 жыл бұрын
So first thank you for all the learning. I am hooked on these videos. Question however. Unless I am misunderstanding I am trying to do calculated fields/items and I think because I am creating a pivot table containing values from multiple tables the calculated items/fields is greyed out. Any work around for this?
@MyOnlineTrainingHub2 жыл бұрын
Great to hear, Leo! When you're working with a Power Pivot PivotTable i.e. when your data is in the Power Pivot data model, you cannot use calculated fields or items. Instead you write DAX measures. If you'd like to learn DAX, please consider my Power Pivot course: www.myonlinetraininghub.com/power-pivot-course
@mariakuriakose42939 жыл бұрын
Thank you for sharing this useful tip. Your videos are making global impact!
@MyOnlineTrainingHub9 жыл бұрын
Maria Kuriakose thank you! I'm glad you found them useful :-)
@relms1403 жыл бұрын
Thanks for this, really helped :)
@MyOnlineTrainingHub3 жыл бұрын
Great to hear 😊
@aiasaiascon3894 Жыл бұрын
I was not aware of the Calculated Items concept even though It was there all the time!!! WOW Thank you so much!!!
@MyOnlineTrainingHub Жыл бұрын
You are so welcome! 😊
@user-ei1tp8qn8d Жыл бұрын
Thank you, Mynda) Your explanation of the difference between a field and an item makes it much clearer.
@MyOnlineTrainingHub Жыл бұрын
Glad it was helpful!
@svk8533 жыл бұрын
Another brilliant video. Thank you for sharing these great tips Mynda
@MyOnlineTrainingHub3 жыл бұрын
You are most welcome, Susan!
@lances299 жыл бұрын
Mynda as always you have valuable tips. Excellent!!
@MyOnlineTrainingHub9 жыл бұрын
Thanks, Lance Smith , Dane and Nikolas :-)
@777kiya2 жыл бұрын
Hi, thank you for the video. What I want to know is, why should I use the Calculated Item in place of Calculated Field? Thanks
@MyOnlineTrainingHub2 жыл бұрын
Hi Hiruy, I explain this in the video, but you'll also find a written explanation with screenshots that you might find easier to follow: www.myonlinetraininghub.com/excel-pivottable-calculated-items
@iziaurrahman2 жыл бұрын
Used calculated fields a lot and always wondered what calculated item means? Now I know the use of calculated items. Thanks
@MyOnlineTrainingHub2 жыл бұрын
Glad to be of help, Ziaur!
@shoaibrehman99883 жыл бұрын
Hi, Thanks for the video 2 question raised. 1. It won't work ( calculated field) if we tick (Add this data to data model) during insert pivot table. 2. How can we edit it if any changes required like in IF formula used in this video. Thanks Shoaib
@MyOnlineTrainingHub3 жыл бұрын
Hi Shoaib, Indeed, this is not for Power Pivot (data) models. For Power Pivot you must use DAX measures. You can edit your formula by going back into the add calculated field dialog box and choosing your formula from the drop down list.
@LucasSuavinha6 жыл бұрын
The most useful video showing advanced pivot tables techniques! Thank you for this great job!
@MyOnlineTrainingHub6 жыл бұрын
Thanks, Lucas :-) Glad you found it useful.
@ravishete26023 жыл бұрын
Fantastic!!:-) Never thought that a table with % & number can be converted into pivot, Nice tip of shuffling.
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it, Ravi!
@iankr3 жыл бұрын
Great stuff, thanks. I'm learning so much about pivot tables from you, and how useful they can be. I've been using Excel for years now, and have always shied away from pivot tables.
@MyOnlineTrainingHub3 жыл бұрын
Great to hear, Ian! I'm sure you'll love PivotTables the more you use them.
@mumbaluapula52854 жыл бұрын
Thank you, I can now work out calculations from within pivot tables
@MyOnlineTrainingHub4 жыл бұрын
Awesome to hear!
@NikolasLarum9 жыл бұрын
Thank you for putting this tutorials together. Love the KZbin format.
@dhirajsuvarna4483 Жыл бұрын
I love your content, very helpful. Thanks a ton
@MyOnlineTrainingHub Жыл бұрын
Happy to hear that!
@prasadmoghe17022 жыл бұрын
Greetings I love your teaching style and the worksheets you present. I have acquired Dashboard skills nicely from your videos. I hope to learn more from your going forward. Keep teaching and impart us with your rich knowledge. Regards
@MyOnlineTrainingHub2 жыл бұрын
So pleased to hear that, Prasad. Please consider my Excel Dashboard course if you want to take your dashboard skills to the next level: www.myonlinetraininghub.com/excel-dashboard-course
@douglasbrown53299 жыл бұрын
Outstanding! Thank you for this very helpful and informative video. Actually, all your videos are top quality and I have learned so much from you, especially from taking your Dashboard class Thank you again!
@MyOnlineTrainingHub9 жыл бұрын
Douglas Brown Thank you! :-)
@unastewart39927 жыл бұрын
This video is excellent.It covers everything I wanted to know.
@ankursharma6157 Жыл бұрын
Hi Mynda, 1stly, Thank You Very, Very Much for Sharing Your Invaluable Wealth of Knowledge with All of Us 🙏🏾 Mynda, I practiced Calculated Item and Calculated Field on My dataset. For Calculated Item, I changed the order in Rows Area to change the Calculated Item formatting to % . . like You did in the video. When I switched the order back, the % formatting again changed to number formatting. 🤔 In the PivotTable Options, the option "Preserve cell formatting on update" is selected. Would You be able to suggest what could be the reason? Thank You! Best Wishes!
@MyOnlineTrainingHub Жыл бұрын
Sounds like you used the number formatting for the cells instead of for the field. Select one of the numeric cells you want to format > right-click > Number Format (instead of Format Cells).
@ankursharma6157 Жыл бұрын
Hi Mynda, Truly appreciate Your prompt response 🙏🏿 I will be Grateful if You respond to the following OR even if You are not able to. You already help Us so much 🙂 My PivotTable is as follows: Rows Area - (1) Region (2) Order Status Values Area - Sum of Sales I created Calculated Item for Order Status. To apply formatting, I switched the Rows Area to - (1) Order Status (2) Region. None of the following methods help when I switched in the Rows area. 1st method - I select 1 of the numeric cell . . apply % formatting via "Number Format". The % formatting gets applied to all numeric cells. 2nd method - I select the numeric cells of which I want to change formatting to % formatting . . click on the % symbol on the Home tab as it is shown in the video. Thank You!
@mattmatt2454 жыл бұрын
You can also swap Type with Month and do calculated field instead.
@MyOnlineTrainingHub4 жыл бұрын
Yes, you could. I cover calculated fields here: www.myonlinetraininghub.com/excel-pivottable-calculated-fields
@italianstallion75396 жыл бұрын
After toying with the formulas for my pivot table for a while i was able to successfully implement my % of revenue formula...thank you for the video
@MyOnlineTrainingHub6 жыл бұрын
Well done, Anthony. Glad I could help. :-)
@johnborg54194 жыл бұрын
Going through some your videos which I am finding very interesting. Thanks Myndy. : )
@MyOnlineTrainingHub4 жыл бұрын
My pleasure, John :-)
@jajis2 жыл бұрын
thanks for the Tutorial Video, I would like to know if it is possible to do the calculations for the grouped Fields
@MyOnlineTrainingHub2 жыл бұрын
You can't add a calculated column in a PivotTable with grouped data. Instead you'd have to use Power Pivot and write DAX measures.
@srodgers664 ай бұрын
I had the same question. Calculated Items is a nice feature (and this is a great video), but I can't think of a Pivot table I have created where I don't use Date grouping. Which unfortunatley makes it not useful for me.
@gonzalochavez20068 жыл бұрын
Excellent tip. Great video.
@MyOnlineTrainingHub8 жыл бұрын
+Gonzalo Chávez Cheers :-) Glad you liked it.
@jhunter90639 жыл бұрын
Another great tip! If I could only learn as fast as you can teach!
@FarhanMerchant3 жыл бұрын
Very Informative ; thank you
@MyOnlineTrainingHub3 жыл бұрын
Glad it was helpful!
@user-ry3iv9qq7r9 ай бұрын
Hi Mynda To begin with, I want to thank you for ur training. Would you pls let me know why didn't you use measure instead of the calculated item? Can we prepare the report with the measure too? What is the difference between the measure and calculated items? Appreciated in advance
@MyOnlineTrainingHub9 ай бұрын
Thank you! Measures only work with Power Pivot PivotTables. Calculated Fields & Items are for regular PivotTables.
@toque159 жыл бұрын
Great video! Precise and well explained :) Thumbs up
@islamabdeen96702 жыл бұрын
thanks for your effort
@MyOnlineTrainingHub2 жыл бұрын
My pleasure 😊
@rishabjain37009 жыл бұрын
This is really very helpful. Thanks a ton!
@MyOnlineTrainingHub9 жыл бұрын
rishab jain glad I could help :-)
@Kursatural Жыл бұрын
Thank you so much!
@MyOnlineTrainingHub Жыл бұрын
Glad it helped!
@EyiBillion3 жыл бұрын
Yes! I like it and the button enjoyed the hit. Always brilliant
@MyOnlineTrainingHub3 жыл бұрын
Glad you enjoyed it, Eyitayo!
@evgenyshatskih96933 жыл бұрын
Thanks for the great tutorial. What I noticed though is that the calculated items can freeze Excel. Apparently, it can be very demanding for some files to run. Any insights into how to overcome the issue?
@MyOnlineTrainingHub3 жыл бұрын
Hi Evgeny, I've not experienced that problem, but if you're file is freezing then it might be time for Power Pivot and DAX measures insead.
@adrianogiacomini65413 жыл бұрын
you are always the best
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much, Adriano!
@tmarkussen3 жыл бұрын
Great video thanks!
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it!
@mosheslonim32559 жыл бұрын
Great tip. As always!
@ernievanstedum24414 жыл бұрын
Thank you so much! Very help indeed.
@pawarlaxman2253 жыл бұрын
I am not good @excel,your mastery in excel leaves me in ashes.
@MyOnlineTrainingHub3 жыл бұрын
Hopefully you can learn some things and bring your Excel skills up to speed with my videos :-)
@RohitThakur-ku8sb4 жыл бұрын
Hi Mynda , I need ur help with calculated field. I want to calculate % of target vs achieved for every item,not with the total of the column. Column b has target , column c has achieved count and need to calculate %of target achieved in column D. Please help.... Aside , I am learning Excel and your sessions are really helping me. Thank you so much ....
@MyOnlineTrainingHub4 жыл бұрын
Glad you're enjoying the lessons, Rohit. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@karimamkar95383 жыл бұрын
Hello dear thanks for your helpful videos,I need your help if possible. I have a set of data in power pivot and try to create a pivot table from it with filters. let's say i have three tables: T1 [stores] : id, name T2 [expenses] : id, Cost, date of expense T3 [sales] : id, amount, date of sale i want to create a pivot table to show the stores with expenses and sales dates in a specific date range (filter), but excel applies by default AND logic and shows only stores with both expenses and sales in that range (what i want is to show the stores that have either an expense or sale in that range 'OR' logic). I tried many ways but no solution. i lookedup every video and every page on Google :S. Thank in advance.
@MyOnlineTrainingHub3 жыл бұрын
Hi Karim, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@karimamkar95383 жыл бұрын
@@MyOnlineTrainingHub Thank you
@claudiomarziani83419 жыл бұрын
Simply genial. Thank you so much.
@supersayan9888 Жыл бұрын
Amazing video. I am curious tough, is it possible to unpivot in power pivot 😀. I want users to selects all the columns and measure they need and then unpivot it to a straight table.
@MyOnlineTrainingHub Жыл бұрын
Thank you! If you double click on the value field in the PivotTable that you want to see the underlying values for, Excel will open a new sheet containing the table.
@karlosmuller21312 жыл бұрын
Thank you so much
@MyOnlineTrainingHub2 жыл бұрын
My pleasure 😊
@itachy3944 жыл бұрын
thank you very much , your video is very helpful as usual
@MyOnlineTrainingHub4 жыл бұрын
Glad to hear that, Mohamed :-)
@sulaiman14083 жыл бұрын
Hi, Mynda. Thank you for this informative video. I have question. I can’t choose “Calculated Field” in analyze ribbon because it’s not activated! How can I activate it?
@MyOnlineTrainingHub3 жыл бұрын
It sounds like you may have loaded your data to the Data Model. Calculated Fields aren't available for the data model. Try creating the PivotTable again, this time make sure you don't check the 'load this to the data model' button.
@peterl28663 жыл бұрын
Hi Mynda, another great video explained very well ! Ok here’s a tricky one for you. I have a data table that shows the date that each step in a 7 step process was completed. I want to add a pivot table that will give me the timespan in days between step 1 and step 2, step 2 and step 3 etc etc... because I do not want the data table to show this calculation can this be done using calculated fields/ items in the pivot table?
@MyOnlineTrainingHub3 жыл бұрын
Thanks, Peter! You can use 'Show Values As > Difference From' to calculate the difference from one date to the next: www.myonlinetraininghub.com/excel-pivottable-show-values-as
@peterl28663 жыл бұрын
Perfect 👌 thank you so much you’ve saved me so much time!!
@syed5994 жыл бұрын
Very helpful
@MyOnlineTrainingHub4 жыл бұрын
Great to hear!
@nishadnandakumar51422 жыл бұрын
Thank you
@MyOnlineTrainingHub2 жыл бұрын
You're welcome 😊
@1566153 жыл бұрын
GREEATTT so many learnins brilliant as usual Mynda
@MyOnlineTrainingHub3 жыл бұрын
Pleased to hear that, Amrish :-)
@herminiotorresnyc4 жыл бұрын
Hi Myndy, your training's are truly amazing and incredibly helpful. Wondering if you could touch on a few advanced Pivot tables? I colleague of mine, prepares these robust pivot tables that including Vlookups and mapping data which confuse me and I could never figure out how he was able to complete them. Wondering if I could share one with you and have you comment. Thanks,
@MyOnlineTrainingHub4 жыл бұрын
Great to hear you're finding my tutorials helpful, Justin :-) Please post your file on our Excel forum and I'll gladly take a look: www.myonlinetraininghub.com/excel-forum
@nirajkumarshah97743 жыл бұрын
Nice Video; it helps lot
@MyOnlineTrainingHub3 жыл бұрын
Glad to hear that!
@benysmart164311 ай бұрын
Merci Mynda
@MyOnlineTrainingHub11 ай бұрын
Most welcome 😊
@ambarilhamchannel2 жыл бұрын
Dear Mynda, I used to calculate item by using formula 1-sumif($upper ref:upper ref,cell ref,$upper data:upper data), that formula really takes time. I still not found how to calculate how many items for backlog (due under current Month), current months, and future due date. I usually put qty, and items on the next column. If you don;t mind can you let me know your email, and I will send you the calculation I made, and I want you simplify the calculation. Thanks for your response
@ksoonsoon9 жыл бұрын
Well done - thank you
@vijaysahal45562 жыл бұрын
Nice 👍🏻👍🏻👍🏻but pls here put it rowdata dowenload link so that we can home work with data
@MyOnlineTrainingHub2 жыл бұрын
The download link is in the video description.
@TheBtrivedi3 жыл бұрын
Wow. Such a nice video.
@MyOnlineTrainingHub3 жыл бұрын
Thank you 🤗
@YARANODERA4 жыл бұрын
Thank You For Such Great Video
@MyOnlineTrainingHub4 жыл бұрын
So nice of you :-)
@miraflormerino6272 жыл бұрын
Thanks its helpful
@MyOnlineTrainingHub2 жыл бұрын
Glad to hear that
@bloggermanpreet3 жыл бұрын
Thanks ma'am 🙂👍
@MyOnlineTrainingHub3 жыл бұрын
Most welcome 😊
@clearclara52902 жыл бұрын
Great Video. Thumps up
@MyOnlineTrainingHub2 жыл бұрын
Thank you very much!
@ArnieWoolf9 жыл бұрын
Excellent tip. Thank you :-)
@MyOnlineTrainingHub9 жыл бұрын
Arnie Woolf, you're welcome! :-)
@ganeshkrishnan40219 ай бұрын
Hi, can u guide me how to add YTD column for actual and budget columns within a pivot so that I can show variance column easily as a calculated fied within pivot?
How can I calculate items from different field inside 1 pivot table, Ma'am? Thanks
@MyOnlineTrainingHub3 жыл бұрын
Not sure what you mean, Leo. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@sachinkishore41156 жыл бұрын
Thanks a lot . It's very useful to me.
@MyOnlineTrainingHub6 жыл бұрын
Great to know it helped.
@Evve05213 жыл бұрын
enjoy watching it. thank you.
@MyOnlineTrainingHub3 жыл бұрын
Great to hear that :-)
@prajwalshetty20473 жыл бұрын
Nice Video 👍
@ahmed007Jaber2 жыл бұрын
Hi there Thank u for this Is is possible to add a line with customised field under a group subtotal?
@MyOnlineTrainingHub2 жыл бұрын
Not sure what you mean, Ahmad. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@amilarambukwella5102 жыл бұрын
YES, TIME SAVING
@MyOnlineTrainingHub2 жыл бұрын
Great to hear!
@amilarambukwella5102 жыл бұрын
@@MyOnlineTrainingHub Yes, and this wont work on combined Pivots as it doesn't show to add Calculated Field ? Appreciate your help on this as well.
@ahmed007Jaber2 жыл бұрын
I have been using pivot tables for a bit and they are time saving at times. I have a database of projects their budgets and costs. I know that I can create custom subtotals and custom calculated columns, but was wondering if i could add a line underneath a subtotal to do a calculation e.g. i have one budget for the whole project but several categories of expenses. So I need to show the breakdown of expenses and at the end sum of it and then a new line showing the value of surplus or deficit. Another thing I just noticed, if I added it to a data model to create a measure and check the variance, I am not able to choose custom subtotals I would prefer to do it without VBA, but if it is a must, why not
@paulabrudny4237 Жыл бұрын
have you tried Grouping the lines? as far as I can understand the problem, that could work....
@nishadnandakumar51422 жыл бұрын
Good video
@AR-rs2dy4 жыл бұрын
Wasn't even aware of this feature. Loving the vids.
@MyOnlineTrainingHub4 жыл бұрын
So pleased to hear that :-)
@MrVenterW Жыл бұрын
Thank you Myanda for this video. I am using Excel 365 and the Calculated Field and Calculated Item lines are greyed out. What should I do to activate them. Kind regards
@MyOnlineTrainingHub Жыл бұрын
Sounds like you’ve added the data to the data model on PivotTable creation. If so, you can’t use these techniques and would have to write DAX measures instead. Or recreate the PivotTable without adding the data to the data model.
@MrVenterW Жыл бұрын
@@MyOnlineTrainingHub Perfect. Thank you so much
@royyajayanthkumar67233 жыл бұрын
Thankyou can you show me separate video showing row percentage of grand total and grand total , percentage of columns total , Column totals showing in same pivot .. when we have column values included in Pivot table...
@MyOnlineTrainingHub3 жыл бұрын
Sorry, I'm not following what you want. Please post your question and sample Excel file with examples on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@josephoketch73283 жыл бұрын
great , thanks
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it!
@andresantoniocastroperez84293 жыл бұрын
thank you didactic and useful. Please can you tell me if there is a way to build series with annual values putting in last month and taking out first one each month goes by with pivot tables?
@MyOnlineTrainingHub3 жыл бұрын
Cheers, Andres! You'd need to use DAX measures in Power Pivot to create a rolling annual total. It can't be done with regular PivotTables, sorry. If you'd like to learn DAX and Power Pivot, please consider my course: www.myonlinetraininghub.com/power-pivot-course
@escott58396 жыл бұрын
Excellent video thanks
@MyOnlineTrainingHub6 жыл бұрын
Thanks, Edward! Glad you found it helpful.
@skcp1513 жыл бұрын
When I am doing the ROE in the calculated items by using the equation net profit /equity showing error as #Div/0!..why not getting the actual figure
@kashmoney13 жыл бұрын
can you please let me know if we can move calculated fields (whole pivot) into another workbook with the same database? It is currently not working for me when I refresh after moving the tabs. Please advise! Thanks!
@MyOnlineTrainingHub3 жыл бұрын
Hi Akash, no, the Pivot Cache that Excel uses to reference the data for the PivotTable is saved in the original file. You can File > Save As and make a copy of that file, but sometimes this messes up PivotTables too.