Not only was this extremely helpful, but it only took 5 minutes of my time. Bravo for an informative AND efficient video.
@contextures
2 жыл бұрын
Thank you, Brian, and I appreciate hearing that! --Debra
@dumbwaiter
Жыл бұрын
Contextures is a neat website for excel users without endless scrolling. Def one of the sources I check first. Thank you for these great videos.
@contextures
Жыл бұрын
You're welcome, Güneycan, and thanks for your lovely comment - I appreciate it!
@eranaharonov8494
2 жыл бұрын
This is the first video I see from you, it is short, to the point, and explained very clearly. Thank you!!
@contextures
2 жыл бұрын
You're welcome, Eran, and thanks for letting me know that you like the video!
@ShankarBShetty
3 жыл бұрын
You are a born teacher Madam. Fantastic!
@contextures
3 жыл бұрын
Thank you, Shankar!
@LeoInnecco
2 жыл бұрын
Very useful, thank you
@contextures
2 жыл бұрын
You're welcome, Leo, and thanks for your comment!
@chrissaz6977
3 жыл бұрын
Very clear in explanation, thanks!
@contextures
3 жыл бұрын
You're welcome, Chrissa, and thanks for your comment!
@murtuzalal
2 жыл бұрын
This was great helpful to me thanks for this tip and tricks
@contextures
2 жыл бұрын
You're welcome, Murtuza, and thanks for letting me know the video helped you!
@MySpreadsheetLab
5 жыл бұрын
Thanks for the reminder Deb! I sometimes forget about Calculated Items....they are use helpful.
@contextures
5 жыл бұрын
Thanks, Kevin! Excel has so many features that it's impossible to remember them all
@bhirappashellikeri9923
Жыл бұрын
Thank you it's useful video. I have question.whether its possible to use ppm formula for grand total that is showing at the end
@gabespalding8964
5 жыл бұрын
Thank you Debra, very well explained.
@sokratespanopoulos7143
2 жыл бұрын
Thanks very much..
@contextures
2 жыл бұрын
You're welcome, and thanks for your comment!
@wayneedmondson1065
5 жыл бұрын
Hi Debra.. thanks for the tip on calculated Fields and Items and especially the List Formulas choice.. had not used that before. Thumbs up!
@contextures
5 жыл бұрын
You're welcome, Wayne, and glad to show something you haven't used before!
@louism.4980
Жыл бұрын
Thank you :)
@contextures
Жыл бұрын
You're welcome, Louis, and thanks for your comment!
@GladwinNewton
2 жыл бұрын
thanks
@contextures
2 жыл бұрын
You're welcome, Gladwin, and thanks for your comment!
@psy377
7 ай бұрын
im always getting the error "There are too many records to complete this operation." For how many lines will the calculated filed work?
@contextures
7 ай бұрын
Excel limits are on this Microsoft page, and shows "limited by available memory" for many pivot table features. support.microsoft.com/en-au/office/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3
@martyhester811
3 жыл бұрын
My calculated field does not show up in the Field List?
@parmjeetkaur3635
4 жыл бұрын
its awsom description ...must watch....
@AsIsAs1000
Жыл бұрын
I could not find grand total when i wanted to create calculated item or field within the same item... i need to divide two field items to get a percenatge ... couldnt do it!
@contextures
Жыл бұрын
Instead of a calculated field, try the Show Values as feature. This video shows % of Parent, but you could use % Of... kzitem.info/news/bejne/r5CXs4qfq3aJpaw
@bintang13t
3 жыл бұрын
Thank you, That's all
@aravindhkrish5456
3 жыл бұрын
Thanks for helpful tips
@contextures
3 жыл бұрын
You're welcome, Aravindh, and thanks for your comment! - Debra
@ZAHIDHUSSAIN-ri5kg
5 жыл бұрын
Many thanks Debra!
@contextures
5 жыл бұрын
You're welcome, Zahid, and thanks for your comment!
@devrajpreetham
2 жыл бұрын
Thank you Debra for the effecient video. I am in a puzzle, Lets say I have columns 1 to 10 and need to calculate only 9&10 is it possible?
@contextures
2 жыл бұрын
You're welcome, Preetham, and the calculated field would apply to all the columns - you can't exclude specific columns
@shoppersdream
3 жыл бұрын
Thanks! Very Nice. Can you give more examples of when to use Calculated Items and when to use Calculated Fields that is not very clear to me at this moment? Thanks
@MarkPrimavera
2 жыл бұрын
Thank you Debra for this well explained video! I have a situation where I have a sheet containing tree diameters and tree health, the health are from 1 to 4 and 4 being dead. So what I would like to do is show the counts of dead trees (4) in my pivot table.
@contextures
2 жыл бұрын
You're welcome, Mark, and thanks for your question. In the pivot table, put Health in the Rows area. Then, put another copy of Health into the Values area. Right-click on the value field, click Summarize Values by, click Count. Then, if you only want to see the #4 trees, filter the Row field to show 4 only
@MarkPrimavera
2 жыл бұрын
@@contextures Double thumbs up Debra for that help! Worked like a charm! Thank you Debra :)
@ca.lakshminarayanreddyjamb9087
5 жыл бұрын
Thanks a lot. I was looking for this.
@Hemanthg7
Жыл бұрын
How to display the Analyse tab on ribbon
@contextures
Жыл бұрын
Select any cell in the pivot table, and new tabs should appear on the Ribbon -- they have different names in some versions of Excel. For example, in Excel 2007, you'd click the Options tab, and then Formulas.
@adityaagarwal4444
3 жыл бұрын
Can you suggest how we can sum multiple items when choosing the items to add to arrive at calculated item. In your example: a formula to add all order status less "cancelled" order status. kindly advice. thank you
@fardinkhan6027
5 ай бұрын
Well if I click on Calculated Items this appears to me "If one or more fields in the PivotTable have calculated items, no fields can be used in the data area two or more times, or in the data area and another area at the same time. If you are trying to add a field, remove the calculated items and add the field again. If you are trying to add a calculated item, change the PivotTable report so that no field is used more than once and then add the calculated item." Now please help me how can I use calculated item in excel.
@gmo709
2 жыл бұрын
Trying to figure out how to edit the formula. I still do not know how to do that. Any idea how to edit a formula we used for a calculated field?
@contextures
2 жыл бұрын
This video shows how to change a calculated field's formula: kzitem.info/news/bejne/k6Rnu2WiiKKdfWk
@jalindarthorat9177
3 жыл бұрын
I have problem to connect timeline to two pivot chart or graph.after connect of timeline to graph one graph working fine but second take multiple dat.Please help it is much need to me .
@trevorl3648
2 жыл бұрын
Thank you for the video. Is it possible to create a formula with calculated fields that uses two different columns? For example, if in my pivot table I have a revenue column and an expense column, can I use a calculated field to subtract the expenses from the revenues?
@contextures
2 жыл бұрын
You're welcome, Trevor, and thanks for your question! If the revenue and expense are in different columns in your source data, use a calculated field like this in the pivot table: =Revenue - Expenses
@ibnuamaru
2 жыл бұрын
my calculated field/items menu is disabled (not clickable), why is that?
@contextures
2 жыл бұрын
If you checked the "add to data model" box, when creating the pivot table, those commands aren't available, because the pivot table is OLAP-based.
@ibnuamaru
2 жыл бұрын
Thanks alot for the answer, it's working now.. But i have another question.. is it posible to place "values" type to the left of "rows" type in vipot table?
@ibnuamaru
2 жыл бұрын
If it's not posible, do you have another trick to add serial number column on the left of "rows" type?
@contextures
2 жыл бұрын
@@ibnuamaru No, the values are always to the right of the rows
@contextures
2 жыл бұрын
@@ibnuamaru You could put the serial number into the Rows area, before the other fields. Change its setting to repeat in all rows, if you want that. Turn off subtotals for serial number, and use Tabular layout
@yoelleny
3 жыл бұрын
create pivot table from 2 tabs, the calculated field options doesn't work anymore, please help
@lightinformations9936
4 жыл бұрын
How to add calculation field base on add to value field
@sundayb.3488
4 жыл бұрын
I can't locate the data file used in this video. The one on the link that I had to search for (should be easier to find) does not match the video.
@derimaulana
4 жыл бұрын
hi...thanks for your explanation its very helpful, how can I use calculated fields when im in "data model pivot"? why im using the data model pivot, its becs i have to eliminate duplicates items in pivot, but in other way I also have to accumulate the data in few columns. looking forward for your adv. Thanks
@Congenialable
5 жыл бұрын
Grand total row does not show correct figure of growth%. It sums the column items.. How to get it right???
@pratikagrawal7783
3 жыл бұрын
How can I add Slicer in Calculated Field in Pivot Table
@samkab677
4 жыл бұрын
Hi How to subtract east total from west total?
@jayakumarsubramani7285
4 жыл бұрын
It shows group error. Please help me out to solve it
@dasrockness
3 жыл бұрын
What about getting a percentage? I have a pivot of the counts of different categories and a grand total. I'd like to get a percentage of calculation in the pivot. So (grand total-missing)/grand total for a percentage of the grand total that are missing. I've been stuck on this one for a while.
@contextures
3 жыл бұрын
This might do what you need - add the same field again, and set it to show the count. Then, right-click on one of the numbers, click Show Values As, and click on % of Column or % of Parent Column. I've got a short video here: kzitem.info/news/bejne/r5CXs4qfq3aJpaw
Пікірлер: 73