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.
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!!!
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
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!
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
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?
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
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.
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
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
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!
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!
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).
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!
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?
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
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
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?
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.
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?
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
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 ....
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
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?
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
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,
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
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
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
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.
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.
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.
Hi Vansh, You only see the calculated field option when you're working with regular PivotTables. Perhaps you added your data to the data model/Power Pivot? More on calculated fields here: www.myonlinetraininghub.com/excel-pivottable-calculated-fields
Yes, but it's done using DAX measures, which is a bit more complicated, but also much more powerful. If you'd like to learn DAX please consider my Power Pivot course: www.myonlinetraininghub.com/power-pivot-course
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?
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
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.
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!
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.
Nice, thanks! Mynda, I got a Pivot Table made by someone else and I am seeing one column in the Pivot Table Field List which shows me the Filter icon next to that field but I am not seeing that field in the Data Source. Why is it showing the Filter Icon in the Pivot Table Field, how did it come, and why is this field not appearing in the Data Source? Do you have any video where some fields are showing with Filter Icon in the Pivot Table Field List but they are not part of the Data Source? I am trying to understand this data in the Pivot Table. Thanks
It sounds like the field may have been renamed in the PivotTable itself. You can right click on the field and open the field settings dialog box to find out the column name in your source data.
Not sure what you mean, sorry. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
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.
thank you , While making a pivot table, and when I inserted a field for the quantity again to make percentages, this message appeared (multi data fields of tah same field are not supported when apivottable report has calculated items problems) how can i fix it
Hi Mohamed, the error message explains it. You can't use a field in the values area twice when you have a calculated item in your model. It's either one or the other I'm afraid.
You are purely awesome and saviour in time of need...i always thank God for directing me to your channel
Great to know you find my videos helpful, Peter :-)
thanks for the Tutorial Video, I would like to know if it is possible to do the calculations for the grouped Fields
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.
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.
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!!!
So pleased I could help 😊
Hi
this is the best Pivot Table video on UA-cam. What you taught here took me 18 months to teach myself. I wish I would have found this in 2016 2017
Thank you! It's great to know the video will be helpful to others :-)
Excellent presented in very simple way to understand.
Glad you liked it, Santosh!
Best Excel tutor I have ever seen, great work Mynda, Thank's alot
Thanks so much, Hasan!
You are an excellent teacher Mynda
Thanks so much, Marty!
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
David Blumberg Aw, thanks :-)
Thank You, Mynda!
+
It is really commendable of You to respond to All Comments. Praiseworthy!
You're welcome, Ankur! I think if you've taken the time to post a comment then it's only polite to respond :-)
Your explanation of the difference between Calculated Field vs Calculated Item was very insightful. Thank you
Great to hear, Graham!
Thanks Myndy for the great video. Really helped me work on an assignment with ease.
Glad I could help 😊
You teach me a lot. Thank you.
My pleasure 😊
Thank you for sharing this useful tip. Your videos are making global impact!
Maria Kuriakose thank you! I'm glad you found them useful :-)
Thank you. Learning so much from you
Glad it was helpful 😊
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
Glad it was helpful!
Another brilliant video. Thank you for sharing these great tips Mynda
You are most welcome, Susan!
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!
Glad you liked it :-)
Thank you, Mynda) Your explanation of the difference between a field and an item makes it much clearer.
Glad it was helpful!
Mynda as always you have valuable tips. Excellent!!
Thanks, Lance Smith , Dane and Nikolas :-)
this video was made in 2015, until today 7 years later it still benefited person like me. Thanks!
Awesome to hear that, Lawrence!
Very helpful to me. Thank you!
So glad to hear that, Mary Ann!
I was not aware of the Calculated Items concept even though It was there all the time!!! WOW Thank you so much!!!
You are so welcome! 😊
The most useful video showing advanced pivot tables techniques! Thank you for this great job!
Thanks, Lucas :-) Glad you found it useful.
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
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
Really helpful, thanks for your time.
Glad it was helpful, Hari!
Thank you for putting this tutorials together. Love the UA-cam format.
This video is excellent.It covers everything I wanted to know.
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?
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
Thanks for this, really helped :)
Great to hear 😊
I love your content, very helpful. Thanks a ton
Happy to hear that!
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.
Great to hear, Ian! I'm sure you'll love PivotTables the more you use them.
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
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
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!
Douglas Brown Thank you! :-)
Thank you very much for your video. Very informative and helpful.
+Davit Meskhi Could you please also explain how to sort the pivot table by inserted calculated column?
+Davit Meskhi select a cell in the values area of the column you want to sort > right-click > sort.
+MyOnlineTrainingHub Thank you so much. I'm feeling dummy right now :). You've helped a lot.
Thank you, I can now work out calculations from within pivot tables
Awesome to hear!
Used calculated fields a lot and always wondered what calculated item means? Now I know the use of calculated items. Thanks
Glad to be of help, Ziaur!
Going through some your videos which I am finding very interesting. Thanks Myndy. : )
My pleasure, John :-)
Excellent tip. Great video.
+Gonzalo Chávez Cheers :-) Glad you liked it.
This is really very helpful. Thanks a ton!
rishab jain glad I could help :-)
Fantastic!!:-) Never thought that a table with % & number can be converted into pivot, Nice tip of shuffling.
Glad you liked it, Ravi!
GREEATTT
so many learnins brilliant as usual Mynda
Pleased to hear that, Amrish :-)
Yes! I like it and the button enjoyed the hit. Always brilliant
Glad you enjoyed it, Eyitayo!
Another great tip! If I could only learn as fast as you can teach!
Great video! Precise and well explained :) Thumbs up
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
Well done, Anthony. Glad I could help. :-)
I could see calculated items coming in very handy on some spread sheets i'm working on now that i know they exist
Glad to hear that!
thank you very much , your video is very helpful as usual
Glad to hear that, Mohamed :-)
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!
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).
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!
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?
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.
Wasn't even aware of this feature. Loving the vids.
So pleased to hear that :-)
Very Informative ; thank you
Glad it was helpful!
Thank you so much! Very help indeed.
Great tip. As always!
Hi there
Thank u for this
Is is possible to add a line with customised field under a group subtotal?
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
How can I calculate items from different field inside 1 pivot table, Ma'am? Thanks
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
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?
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.
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?
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
Thanks a lot . It's very useful to me.
Great to know it helped.
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 ....
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
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?
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
Perfect 👌 thank you so much you’ve saved me so much time!!
Excellent tip. Thank you :-)
Arnie Woolf, you're welcome! :-)
Thank You For Such Great Video
So nice of you :-)
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,
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
Excellent tips
Great video thanks!
Glad you liked it!
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
Thank you! Measures only work with Power Pivot PivotTables. Calculated Fields & Items are for regular PivotTables.
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
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.
@@MyOnlineTrainingHub Perfect. Thank you so much
thanks for your effort
My pleasure 😊
Wow. Such a nice video.
Thank you 🤗
Nice Video; it helps lot
Glad to hear that!
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.
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.
you are always the best
Thanks so much, Adriano!
enjoy watching it. thank you.
Great to hear that :-)
Thanks for the tutorial.
But I can't see "Items" section under the calculated field option. How to enable that?
Hi Vansh, You only see the calculated field option when you're working with regular PivotTables. Perhaps you added your data to the data model/Power Pivot? More on calculated fields here: www.myonlinetraininghub.com/excel-pivottable-calculated-fields
Great Video. Thumps up
Thank you very much!
Nice Video 👍
Excellent video thanks
Thanks, Edward! Glad you found it helpful.
hi Mynda, is it also possible to insert a calculated field within a pivottable in PowerPivot??
Yes, but it's done using DAX measures, which is a bit more complicated, but also much more powerful. If you'd like to learn DAX please consider my Power Pivot course: www.myonlinetraininghub.com/power-pivot-course
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?
Yes, it's explained here: www.myonlinetraininghub.com/show-values-as-percentage-of-another-pivottable-column-total
Well done - thank you
Very nice - Thank you😃
Welcome 😊
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
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.
Could IFERROR have been used in place of that IF statement?
Yes, you could use IFERROR instead.
Very helpful
Great to hear!
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!
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.
Simply genial. Thank you so much.
You can also swap Type with Month and do calculated field instead.
Yes, you could. I cover calculated fields here: www.myonlinetraininghub.com/excel-pivottable-calculated-fields
Can one use a value from a different table for a calculated item?
Not with regular PivotTables. You'd need to load your data to the data model and write a Power Pivot DAX measure.
Nice, thanks! Mynda, I got a Pivot Table made by someone else and I am seeing one column in the Pivot Table Field List which shows me the Filter icon next to that field but I am not seeing that field in the Data Source. Why is it showing the Filter Icon in the Pivot Table Field, how did it come, and why is this field not appearing in the Data Source? Do you have any video where some fields are showing with Filter Icon in the Pivot Table Field List but they are not part of the Data Source? I am trying to understand this data in the Pivot Table. Thanks
It sounds like the field may have been renamed in the PivotTable itself. You can right click on the field and open the field settings dialog box to find out the column name in your source data.
@@MyOnlineTrainingHub Thank You! I will try this on Monday Since my file is on the office computer. Thanks
Hi can i ask a question can we appear on dashboard value sales and quantity on graph while just appear on bar chart of sales value in dashboard
Not sure what you mean, sorry. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
Do you have a video on waterfall charts?
Not yet, sorry. I do have a written tutorial on waterfall charts here: www.myonlinetraininghub.com/excel-waterfall-charts
Merci Mynda
Most welcome 😊
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.
Hi Karim, please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@@MyOnlineTrainingHub Thank you
Thank you so much!
You're welcome, Hanu!
Does calculated items work when a data model is used - and 2 data tables combined in one pivot table?
Hi Luzaan, no, calculated items aren't available when the data model is used. For the data model you need Power Pivot DAX measures.
Thank you so much
My pleasure 😊
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
Thanks its helpful
Glad to hear that
Good video
thank you , While making a pivot table, and when I inserted a field for the quantity again to make percentages, this message appeared (multi data fields of tah same field are not supported when apivottable report has calculated items problems)
how can i fix it
Hi Mohamed, the error message explains it. You can't use a field in the values area twice when you have a calculated item in your model. It's either one or the other I'm afraid.