sales

  1. N

    From API workbook to sales workbook. Automating a sales sheet.

    Hi all, I am attempting to automate my sales info per product order. I am using two workbooks. One workbook is static, pulling info from a marketplace website via APIs. The other workbook is created for each product order. It contains product manifest and product sales sheets. I...
  2. S

    Running total by hour

    Hi, i'm trying to build a running total by hour. I have a power pivot CUBE formula for the time: =IFERROR(CUBEMEMBER("ThisWorkbookDataModel","[TIME].[TIME].&[1899-12-30T10:00:00]"),"") And what i need is to see the total up to this hour. I'm pulling in last years values. If the hour is after...
  3. gmooney

    Calculated Field - Pivot Table with 2 xlPercentOfColumn Fields

    I have a pivot table that is showing sales for some rows as well as the % of total sales for those same rows. I do this for this year and last year time frames. I want to be able to have a calculated field that show what the point difference is between a row's this year percent of total...
  4. W

    Multiple Products by Month over multiple years

    Good day, I have a need to consolidate monthly sales data from multiple years for many products. The sales data is in a spreadsheet for each year. The products sold have had some added and some discontinued over the years, and currently an overall master list does not exist that covers this...
  5. B

    Calculating sales number brackets in a table

    Hello, I'm working on trying to auto-fill a sales table I have by inserting either formulas into certain cells or creating a VBA macro. I'm comfortable working with both so either method to solve this problem would be great. I've recreated the table below since I didn't see a way to attach my...
  6. A

    Top 10 suppliers as percentage of all.

    I am wanting to show the top 10 suppliers by spend and show their respective percentages of total sales. Pivot table easily gives me Top 10 but the options for % don't give the opportunity to compare each of the suppliers spend amounts to total sales, as opposed to % of top 10 spend. any...
  7. F

    Nested subtraction in SUMIFS

    Hi, I'm trying to populate a formula that sums all the sales of a particular item with few conditions: =SUMIFS(Table1[Sales New] - Table1[Sales Change]; Table1[Sales New] - Table1[Sales Change];">0";Table1[Sales New];">0";Table1[Item];"Blue shirt") --> Table1[Sales New]-Table1[Sales Change] =...
  8. S

    Need Help - Pivot Table - Months/Days

    Hi I have the below data and need to be able to show the total for certain dates in each month, for example for February I want to show the first 15 days total while still showing the full total for january. I have tried to insert slicer with day in it but once I select the first 15 days it...
  9. S

    Pivot Table

    Hi I need some help setting up a pivot table. I need to compare sales figures from 2 seperate years for example sales figures from week 1 2016 against sales figures for week 1 2017 for each store. I then need to be able to show the monetary difference between each year and the % difference...
  10. D

    I am trying to match the exchanged rate based on the date of the sales data and convert the currency to GBP, Then make a pivot table to show sales fro

    Attached is a set of sales data. The task is to produce a graph showing the total paid orders in GBP, with the months across the horizontal axis and sales volume (including postage) on the vertical axis. The graph should aim to compare year on year performance and I need a slicer to be able to...
  11. R

    Return result for 1st, 2nd, and 3rd Row

    Hi Everyone, I'm a bit stumped on a formula I'm building. I am trying to return the close date for the 1st, 2nd, and 3rd Sales deal for all of my sales reps. I built out the following formula, which works if the sales rep has actually closed 3 deals. However, if the sales rep only closed 1...
  12. L

    Slicer for age groups

    Hi I have a table like the one below. I inserted a table then I inserted Slicer for age. So I can use the slicer to filter. My question, can I group age into group like this 18-30 31-50 51-65 So the slicer can show only 3 groups only. I know that can be done in Pivot table but can it be done...
  13. R

    Require formula

    Hello, Below is the simple data sales vs safety stock. I need 1 formula which calculates total number of sales more than safety stock. In this case it is 2 <tbody> sales1 safety stock 1 56 2 5 3 1 4 9 5 1 Total numbers sales more than safety...
  14. N

    How to Create Multiple Reports from One Sheet

    I have a large sales data report containing several groups of customers. I would like to automatically generate individual usagereports (separate files so not by tab) for each group every month and save themon a shared drive. I would like to alsohave each report automatically be customized...
  15. S

    different calculation based on dropdown list

    Hello guys, I have got a questions regarding different calculations based on the selection of the drop-down list. In other words, how can I have different calculations based on what variable I select in the drop-down-list? For example, let's say I've got 5 companies and I created a drop-down...
  16. JHawks8221

    Need To Match 2-3 Cells to Show A Result

    Hello, I'm hoping someone might be able to help me please. I have a project that I am working on where our IT department needs a report that shows all of our companies and product numbers, but next to each product, they would like us to enter "sales exist" if it shows that the product has...
  17. B

    VBA - Delete Rows based on Date criteria from second sheet and Paste in New Rows from third sheet

    i'm new to macros but I'm decent at understanding so have gotten a fair amount of simple stuff done recently. mostly off amending recorded macros. let me explain my file. i don't know how to add spaces or borders in here and i just spent like 10 minutes googling that. anyway, there are 3...
  18. S

    Running total of sales prior to now.

    Hi, I have sales by the hour. Each hour I have a cell with the total sales. I'm looking for the best way to have running total, but if the time is after now it will display 0. 1pm $200 $200 2pm $150 $350 3pm $ 75 $425 But if the time is after now then dont give the hourly...
  19. T

    Complicated formula or macro need to add new sale into correct invoice?

    Hi Everyone, hope you can help I need a formula or macro to add new sales to existing sales invoices. we have clients that p[lace orders and pay over 16 instalmentsand offten add new items to the first order When we get and order an invioce schedule is created with dates and amounts due...
  20. P

    loop through each sheet last row

    Hi, I have n number of sheets in the workbook. Sheet 1 contains Customer name on column A, Sales amount on column B. <tbody> A B Customer Name Sales Amount Srinivasan Prabhu N number or Rows </tbody> sheet 2 name is Srinivasan and last row of Column D has sales amount...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top