CountIF in Pivot table only data NO Blanks
Good morning Team,
Need your help on how to calculate the only with the pivot table the amount of locations occupied, with material.
As you can see once we do create the Pivot table, we need to coung on top row 2, How many bins have material or are accuppied. we will like to have this number direct from the Pivot instead of count if on the top. is this possible?
See attach our current way on calculating this information
Appreciate your support on this
thank you
Regards
Jesus Huerta
Last edited by Jesus Huerta; 02-29-2024 at 04:55 PM.
Just a quick question to make sure that I understood the layout correctly.
B2 = 75 ... isn't it supposed to be the same value as B6203 = 85?
I mean does the formula in B2 is not updated yet? or it is not related at all?
If you could include any of the formulas you used in B2:Z2 that would help.
Last edited by MohamedGadAllah; 03-01-2024 at 02:25 AM.
Thank,
Mohamed GadAllah
Good morning
my apologies, All the information attach comes from a data sheets this is the result of the Pivot Table. The pivot is summarizing the bin location to see ALL the ones that contains inventory, the blank ones are empty. the purpose on this is know how many bins are occupied. In row 2 Im counting only the ones with data to have the result. So my question is if just by creating a Pivot tabla can I get only the count of the of the Bins that are accupied with out doing it this way?
Regards
Click any place in the pivot table itself > go up to the Pivot Table Analyze Ribbon > Show Group > click on Field List > Scroll down to Values Filed > click all items one by one > Value Field Settings > Summarize Values By tab > choose Count from the list.
But I've already done it for you in the attached file.
Last edited by MohamedGadAllah; 03-04-2024 at 02:08 PM.
Good morning
thank you this helps, Im adding the actual source where we run every time, we need to calculate how many locations are occupied per profit center.
See attached updated report.
regards
Jesus H
I've added 3 examples, choose the one you like.
If you need any further assistance or if I do not understand your requirement, just tell and I will adjust it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks