Excel PivotTable Calculated Items - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Ambar
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
reply
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
reply
Prajwal
Mam I used separate Power query to append Gross sales of various Branches to find total Gross sales and Sales return of various Branches to find total sales return in two different sheet, in one sheet total Gross sales and in other sheet total sales return. To find Total Net sales, I manually reduce sales return from gross sales. Mam is there any way to do this all calculation in power query itself.
reply
Mam I used separate Power query to append Gross sales of various Branches to find total Gross sales and Sales return of various Branches to find total sales return in two different sheet, in one sheet total Gross sales and in other sheet total sales return. To find Total Net sales, I manually reduce sales return from gross sales. Mam is there any way to do this all calculation in power query itself.
reply
zameeratco
-Multiple Data fileds of the same filed are not supported when a PivotTable report has calculated items-
I am facing above message while Calculating Items Filed year 2020-21 vs 2020-21 for growth purposes, let me hv your email id so i can send the file please..... pls guide and resolve i would be very thankful to you.... Zameer
reply
-Multiple Data fileds of the same filed are not supported when a PivotTable report has calculated items-
I am facing above message while Calculating Items Filed year 2020-21 vs 2020-21 for growth purposes, let me hv your email id so i can send the file please..... pls guide and resolve i would be very thankful to you.... Zameer
reply
Leo
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?
reply
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?
reply
Akram
Older Pivot Tables could show several values in the same cell (number, percentage, etc.). No more.
Suppose I have 10 branches and 150 client deposits. I want to group branches in 2 rows. First row shows branch name and deposits. The second row shows a % (from grand, row, etc.). Any suggestion?
Many thanks
reply
Older Pivot Tables could show several values in the same cell (number, percentage, etc.). No more.
Suppose I have 10 branches and 150 client deposits. I want to group branches in 2 rows. First row shows branch name and deposits. The second row shows a % (from grand, row, etc.). Any suggestion?
Many thanks
reply
mohamed
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
reply
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
reply
Prasad
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
reply
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
reply
Mariatu
Hello, I'm trying to create a pivot chat. I have the pivot table as well as other data outside of the pivot. I want to use the percentages from the outside data which is not in the pivot data source. Can someone please help me?
reply
Hello, I'm trying to create a pivot chat. I have the pivot table as well as other data outside of the pivot. I want to use the percentages from the outside data which is not in the pivot data source. Can someone please help me?
reply
Andriy
Hello. Can anyone help me, please? I need to add a cell on the buttom of a pivot table calculated field which will show a resul of callculation that is not part of the calculated field.
reply
Hello. Can anyone help me, please? I need to add a cell on the buttom of a pivot table calculated field which will show a resul of callculation that is not part of the calculated field.
reply
Talib
hi I get an error when trying to jnsert calculated item is a variance it says unable to insert pivot in this section due to grouping?! Not sure how to overcome this error
reply
hi I get an error when trying to jnsert calculated item is a variance it says unable to insert pivot in this section due to grouping?! Not sure how to overcome this error
reply
Add a review, comment
Other channel videos
