Perfectly explained. Exactly what I was looking for. Thanks
@BarbHendersonconsulting
3 жыл бұрын
Glad it helped!
@damorgman
Жыл бұрын
Did it in at least 1/3 the time of any of the other videos! Thanks!
@BarbHendersonconsulting
Жыл бұрын
I like to make my videos as short as possible, I do not want to waste people's time
@maketaco6683
25 күн бұрын
wonderful video, succinct. Other people make terribly inefficient videos, yours was perfect!!
@BarbHendersonconsulting
24 күн бұрын
I am glad you like it
@jphoenix1112
2 ай бұрын
Straight to the point, no yap 👍
@BarbHendersonconsulting
2 ай бұрын
thanks
@AbhishekSingh-lm9gi
Ай бұрын
@@BarbHendersonconsultingrespect for that
@yogalekshumimarimuthu2173
4 жыл бұрын
Thanks.. it’s straight to the point
@BarbHendersonconsulting
4 жыл бұрын
Glad you like it
@64mustangfan
2 жыл бұрын
Excellent! Thank you, just knowing about calculated fields was all I needed 🙂
@BarbHendersonconsulting
2 жыл бұрын
Glad it was helpful!
@ksherif482
2 күн бұрын
Great video, thanks :)
@BarbHendersonconsulting
2 күн бұрын
My pleasure!
@FergbyFive
5 жыл бұрын
Great information. Are you wearing a bangle or something that is rubbing up against a surface and sending noise down your microphone? I found that a bit distracting.
@vickysingh7868
14 күн бұрын
Nice and easy
@BarbHendersonconsulting
14 күн бұрын
Thanks a lot 😊
@uekikosuke3601
Жыл бұрын
thank you so much
@BarbHendersonconsulting
Жыл бұрын
always welcome
@Abhi-ow1dr
6 ай бұрын
Thanks
@BarbHendersonconsulting
6 ай бұрын
Welcome
@middleclassguy
2 ай бұрын
I don't know what version is my excel but its the online version free Ms Excel in this I have mentioned every data correctly but whenever i am trying to identify total margin profit via adding two fileds in insert calculator filed its showing error
@BarbHendersonconsulting
2 ай бұрын
I don't know whether the online version has this capability
@Kuralai95
4 ай бұрын
Thank you for this video! I already tried simple formulas and it worked well but I cannot figure out IF formula. For example I’m comparing number of items sold in two months. If amount sold in two months sold matched I want to return “match” text, if not then “not match”. Is it possible ?
@BarbHendersonconsulting
4 ай бұрын
I don't think it was designed for that complex of formulas
@sonudhillon3080
3 ай бұрын
Thanks a lot. ❤❤❤❤❤
@BarbHendersonconsulting
3 ай бұрын
Always welcome
@ganeshkrishnan4021
9 ай бұрын
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?
@BarbHendersonconsulting
9 ай бұрын
YtD would have to be a running total but after that I am no accountant
@helenschwartz8818
2 жыл бұрын
She's such a lovely little lady! :)
@BarbHendersonconsulting
2 жыл бұрын
Thank you!
@nicholasmurray398
10 ай бұрын
Thank you :)
@BarbHendersonconsulting
10 ай бұрын
You're welcome!
@maticulex5713
Жыл бұрын
Love you
@BarbHendersonconsulting
Жыл бұрын
glad I could help!
@AbhishekSingh-zw2du
4 жыл бұрын
Thank you It was helpful 👍🏼
@BarbHendersonconsulting
4 жыл бұрын
Glad to hear that!
@DROIDFARM
3 жыл бұрын
THANK YOU!
@BarbHendersonconsulting
3 жыл бұрын
Welcome!
@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.
@BarbHendersonconsulting
5 ай бұрын
I do not know any work arounds
@viswatej9929
2 жыл бұрын
Thank you for your valuable information. I was confused about how you get the additional fields like Year, Month, and Quarterly in Pivot Table filed. Can You please explain it
@BarbHendersonconsulting
2 жыл бұрын
First select you date column, Go to Pivot Table Tools -> Analyze -> Group -> Group Selection. In the Grouping dialogue box, select Months as well as Years. You can select more than one option by simply clicking on it. Click OK.
@osamasaid8476
2 жыл бұрын
THIS USEFUL
@BarbHendersonconsulting
2 жыл бұрын
thank you
@shadmanjohn123
Жыл бұрын
Wonderful
@BarbHendersonconsulting
Жыл бұрын
thanks
@snehaagrawal5337
Жыл бұрын
While doing the same I am getting sum of sum field 1 in pivot table...... please reply with a solution
@BarbHendersonconsulting
Жыл бұрын
by default it comes up with sum, you are able to select other functions
@anguschalmers2766
Жыл бұрын
Can you calculate a field using manipulated data (say min and max) from your pivot table ?
@BarbHendersonconsulting
Жыл бұрын
you would have to enter the formula in the box where I added sum
@NicholasJ-
Жыл бұрын
Actually heĺpfuĺ!!👏👏👏🙏
@BarbHendersonconsulting
Жыл бұрын
I am glad!
@NicholasJ-
Жыл бұрын
Thànk you
@ilyasgarba1621
11 ай бұрын
my excel cannot calaculate field by this methos. Is there any other method than tell plz
@BarbHendersonconsulting
11 ай бұрын
this is the only that I know how to do it!
@ismailismaili0071
6 жыл бұрын
i like that
@halily877
2 жыл бұрын
on my file the "calcılated file" inactive, pleaswe help
@BarbHendersonconsulting
2 жыл бұрын
if you are in the process of creating the pivot table, there should be no reason that it is greyed out. Try again
@michaelcovell4311
10 ай бұрын
But you would never actually do this because Excel does this by default when you move a column into the Values quadrant.
@BarbHendersonconsulting
10 ай бұрын
not if you wanted the values in the values quadrant multiplied by 5.
@prxminent
3 жыл бұрын
Thank you, HIHIHI.
@BarbHendersonconsulting
3 жыл бұрын
Welcome!
@tima9432
Жыл бұрын
Which version of excel is this?
@BarbHendersonconsulting
Жыл бұрын
excel 2019
@tima9432
Жыл бұрын
@@BarbHendersonconsulting Thank you
@aleksandargeorgiev9302
3 жыл бұрын
Thank you
@BarbHendersonconsulting
3 жыл бұрын
You're welcome
@sunny40533
Жыл бұрын
my calculation field is dem cant use ?
@BarbHendersonconsulting
Жыл бұрын
try selecting a field in the pivot table
@nazarkamal8831
9 ай бұрын
👍👍👍👍👍👍
@BarbHendersonconsulting
9 ай бұрын
thanks
@Juan-tb2ww
Жыл бұрын
Lol Barb
@BarbHendersonconsulting
Жыл бұрын
thanks
@arturocarrillo1553
Жыл бұрын
quality of video is poor
@BarbHendersonconsulting
Жыл бұрын
the video should be seen on a computer screen not a phone
@louellamaedizon6189
Жыл бұрын
Then how would you modify it? Like for example, you already made the calculated field but you want to change its formula. TIA for answering! 🤍
@BarbHendersonconsulting
Жыл бұрын
It is difficult to change the formula once it has been created. The easiest way is to remove the calculated field and do again with the formula you would like
@louellamaedizon6189
Жыл бұрын
@@BarbHendersonconsulting oh ok ok, i guess that a hole lol. Thank you so much for this 🤍
Пікірлер: 80