Excellent examples to show the demonstration. Clear and concise. Thank you.
@LearnAccountingFinance
Ай бұрын
Thanks. Glad you found it useful.
@christoslefkimiotis9889
2 жыл бұрын
Ι really do not like pivot tables but this was an eye opener. For example the H1 and H2 calculated items are included in the grand total calculation, so in order to get around this you can disable the grand totals and introduce a new calculated item that will be the sum of the months. Nice video
@jamespaul4618
Жыл бұрын
Thank you. I learned a lot from your video.
@LearnAccountingFinance
Жыл бұрын
Thanks James. Glad it helped.
@darcyg852
Жыл бұрын
Excellent and concise! Thank you!
@Lyriks_
2 жыл бұрын
God bless you richly my friend
@LearnAccountingFinance
2 жыл бұрын
Thank you and you too.
@vishalgali7761
6 ай бұрын
Very well explained. Thank you so much.
@LearnAccountingFinance
6 ай бұрын
Thank you Vishal!
@tahirhanif9669
Жыл бұрын
Thanks for a great presentation
@LearnAccountingFinance
Жыл бұрын
Thank you Tahir. Glad you liked it.
@ashutoshkashyap1700
10 ай бұрын
Well explained please try to explain if the original table data has two headers how do you use it pivot table
@zxyzxyzyzyugfd
2 жыл бұрын
Thanks for the video excellent. How do you solve the issue with your 6 months H1 and H2 sum, of sales Always Working, the sum is doubled which is not correct.
@user-hj6wd6yq9m
Жыл бұрын
Thanks🥰
@ahmed007Jaber
2 жыл бұрын
thank you for this 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
@idwtv534
4 ай бұрын
is it possible to create a new column where i add something to the net sales if they are from specific months? Ex: I want to add the number 1050 to the sales amount for the months of jan, march, sep. I tried doing if(calendar month = 'jan', netsales+1050,netsales) but its not working.
@MediaTechTaghreedAshraf
3 жыл бұрын
very good
@LearnAccountingFinance
3 жыл бұрын
Thanks Media Tech - 53
@verawatichandra1568
3 жыл бұрын
if you show totals on always working CO, can I use calculated fields in this formula: gross sales January / gross sales at always working CO total?
@smart_ideas
2 жыл бұрын
Hi, When I insert a calculated item, then in bottom % is coming wrong. Will please help me how to solve it.
@pardawala_Bhiwandi
3 жыл бұрын
Amezing
@pardawala_Bhiwandi
3 жыл бұрын
Wow
@savissm
2 жыл бұрын
Thank you for the tutorial, quick question, the Calculate Field is grayed out and I even tried different file that I have and even there is grayed out , and it doesnt matter if i select any cell or not still same, any idea what would be the problem? is there any setting I have to turn on that I am not aware of ?
@dougmphilly
2 жыл бұрын
you can't use calculated fields or items if your pivot table is sourced directly from the data model.
@hosseinhosseinpoor9561
2 жыл бұрын
عالی
@yoelleny
3 жыл бұрын
when doing this pivot for multiple tabs, the calculated field options doesn't work anymore, please help
@ubaidillahmuhammad20
3 жыл бұрын
Please put practiced file in the description
@LearnAccountingFinance
3 жыл бұрын
Hello Ubaidillah .. the link is available in the description. Here is the link again ...bit.ly/3uDFmcx
@labully3626
Жыл бұрын
I'm trying to insert Calculated Item, "Gross Profit", calculated as Sales - Cost of sales but I'm getting an error message: "An item name is ambiguous. Another field in the PivotTable report may have an item with the same name. Use the syntax field[item]. For example, if the item is Oranges and the field is Product, you would use Product[Oranges]." What does this mean? How do I correct this error please? The table is the only sheet, other than the pivot table, in the workbook and the "Gross Profit" category does not exist anywhere else. I have no idea how to correct this. Thanks for any assistance you could provide.
@LearnAccountingFinance
Жыл бұрын
Try naming the calculated item differently, eg "GP" instead of Gross Profit
@labully3626
Жыл бұрын
Thank you for your reply@@LearnAccountingFinance . I managed to get assistance. "I suspect there is a name conflict with either Sales or Cost of Sales also used somewhere else. It's asking you to prefix Sales and Cost of Sales with the column name e.g. if the column name is Account, then it wants you to write the formula: =Account[Sales] - Account[Cost of Sales]". This worked, thankfully.
@LearnAccountingFinance
Жыл бұрын
Thanks for sharing the solution.
@gulafshaparveen6797
Жыл бұрын
Hi, how to change $ 4567 to $4567
@LearnAccountingFinance
Жыл бұрын
Hi Gulafsha. Are you asking for a pivot table or generally in a cell?
Пікірлер: 36