User Profile
ndmalam
Copper Contributor
Joined Sep 04, 2020
User Widgets
Recent Discussions
Find Similar suppliers of Different Items in Pivot table
Hi, I want to create a pivot table. I have a Data table which contains list of Purchased items on different date, from different suppliers , on different Rates. I want to find which items are supplied by more than one suppliers also showing rate and date . sample file is attached Best Regards.Solved1.6KViews0likes3Commentspivot table behavior related information required
I have one excel workbook . one table as source data and created many pivot tables with this same source data. in the same work book. when i change the date format in group , it changes in all pivot tables . In some pivot tables i want to show it as year, and in some other as month, how to stop changing all the pivot tables. only one should change where i made change. best regardsSolved1.2KViews0likes1CommentRe: Pivot table, get Average by Total Numbers of months
Riny_van_Eekelen please have a look at the attached file. the problem is when i use average function it averages only counted number of month in which i made purchase. But i want the average of total months that is 11 Months by now.4.1KViews0likes2CommentsPivot table, get Average by Total Numbers of months
I have an excel data table which have these colomns, Purchae date, Item name, Quantity, Supplier name, Now i want to get average of quantity by total number of months. I.e quanty sum is 50 and this is tenth month. So the average should be 5 per month. More over this should keep updating as the month number go on. Best regardsSolved4.3KViews0likes4Comments
Recent Blog Articles
No content to show