sales

Good day everyone, Yet again I have returned with an inquiry. I am trying to work on this sales file where I wanted to extract the daily sales. Here's the screenshot: (Screenshot below is just a part of a big raw file which contains over 6 months worth of sales data) Now, I was able to...

Hi, I have workbook. In sheet 1 I have below <tbody> Customer Name Sales Amount Customer A Customer B </tbody> it continuous n number of customers. And sheet 2 name is Customer A, sheet 3 name is Customer B.. sheet 4..sheet 5 Customer N number.. Each customer sheet has sales...

Hi, I have a DAX formula for MTD I'm looking to total my sales YOY using QTD. So today is the 12 of September I need to see all sales QTD ending today and will compare them year over year. This is my MTD formula: =if(month(dCalendar[dateS])=month(today()) &&...

Hello all I hope you can help on this formula, I want to try to compare day on day sales comparison over 2018 / 2019 At the moment I have a sumifs statement that just adds up for each month and a running total for the year, it's fine for this year as it will add up to today but last year...

The purpose is to ensure that an expected number of new clients will be served by a sales representative on schedule. Normally, you hire sales reps and then get clients, but for the purposes of forecasting I need to do it the other way around. Each sales rep, newly hired, has a training period...

Hello Community, Looking for a little VBA love. Current macro simply done by recording. So I couldn't screw up the language code. I have 2 sheets: 1 for Brands and Brands Top Gain Loss. I would like to get rid of one sheet and allow a macro for Sort by "Dollar Sales" and "Dollar Sales Chg YA"...

Hi I have the following to return 2 seperate numbers: =AVERAGEIFS('Sales History'!T:T,'Sales History'!B:B,A8,'Sales History'!C:C,"Surrendered") =AVERAGEIFS('Sales History'!T:T,'Sales History'!B:B,A8,'Sales History'!C:C,"Current") How do I get an OR statement into it so it brings back a...

<tbody> SKU Type KW1 KW2 KW3 SUM SKU1 Actual Sales 30 41 28 99 SKU1 LY Sales 46 41 25 113 SKU1 Forecst 40 42 43 125 SKU2 Actual Sales 1084 793 2022 3899 SKU2 LY Sales 950 958 765 2672 SKU2 Forecst 871 790 1659 3320 SKU3 Actual Sales 44...

Hi: Can someone please help me with this? I have the monthly sales organized in this way: Jan-19 (Column A), Feb-19 (Column B), Mar-19 (Column C), ...., Dec-19(Column L) I would like to calculate the YTD (year to date) sales based on a picking list (I now how to do the picking list). For...

I feel like that's a weird subject but here's what I'm trying to do. I've analyzed year over year sales by customer and identified when a customer was new, if they were an existing customer but their total sales increased, decreased or stayed flat YoY, or if they were lost. (None would indicate...

Hi, I need help with a formula that works out a commission based on the number of sales you get. The ount of commission you get is tiered dependant on number of sales 1-4 sales = £5 each 5-9 sales = £7.50 each 10+ sales = £12.50 each I have tried using a formula with IF statements but that...

Hi All, Currently, I'm trying to resolve TSP problem regarding number of people need to cover stores in a day. What I'm thinking currently is to setup a constraint and actual working minutes & velocity to travel to stores as per current below. However, I'm stuck with the formula on how can I...

Hi guys, I have some code that does its job in adding datafields to a pivot table. I linked it with a form control button: Sub PDA1P() ' ' PDA1P Macro ' Adds all 1P PDA columns into values of PT ' ' Keyboard Shortcut: Ctrl+Shift+P ' ActiveSheet.PivotTables("SpendTable").AddDataField...

Hello all I hope you can help on this one Column "M" is a sales value Column "Z" has a Sales persons name in Column "H" date the date format "2018-01-19" Column "F" has the year Cell "D4" has the sales person's name in (Drop down Table) Cell "D7" has the Year" (Drop down Table) I have a...

Hi friends! Looking for some help here with formulas (trying to do this without VBA); I've done something similar years ago and can't remember how I did it! :( I am working on a sales tracking workbook. I have Zapier dumping raw data into the workbook from my transaction database and am...

I have a problem I'm trying to analyze. We have to do an analysis on how many new sales reps to hire based on the number of expected onboarded clients. The dynamic part of the problem is that when we hire a sales rep, they have a 2 quarter training period, after which they are able to make a...

Hi Everyone, I have two sheets. 1 "Raw Data" and holds a list of sales 2 "Sales" and is my official Sales list. I need to update one column in Sales with the new data from "Raw Data" so heres what I need. In "Raw Data" column A has a Ref Number. (that's rows 2 to last row) In "Sales" the same...

I have a table of data with three columns: - company code - company name - sales When we use Pivot Tables, we would drag, say, Company Code to the rows field and Sales to the total field. But how about if we wanted to see the company name corresponding to the company code... how would you go...

Hi there, is there anyway that showing data "as a percent of' will relate to the entire dataset? Meaning, for example, that if I have a data-set of car models sales by car makers and I choose to filter 'Audi' in the pivot-table- The percent of sales for A3 model will be in relation to the...

I have a report that I receive weekly Column A will always be Region Column B will always be Color Columns C through Z may change, the order may change, a column that had activity the prior week might not exist because their is no activity. The headers in Column C through Z are known to me...