revenue

Hi, I have a power pivot with two fields in the value section that is further sub divided by an additional field in the column section. Basically we have item transactions (volume and revenue), with multiple types (sales, dump, and destroyed). I want to filter so that items that don't have a...

Hi guys, Here is my problem : I would like to create a measure for incentive calculation. Below my table : I have got a table with following columns : Date; Sales Reps; Products; Actuals Revenue ; Budget Revenue ; Weight This table have relationships with Dimension Date table and Dimension...

Hello all, I have an issue which i am sure is an order of operation issue. Column A: is a percentage of total Revenue for an department. it is derived by departments revenue / overall revenue Column B: is the cost of infrastructure. Column C: I want to see the percentage of the overall...

I'm having real trouble devising a formula enabling me to have calculate revenue based on delaying the revenue by 1 month and then flat lining the revenue over 12 months The base data of 2018 orders in cell F6:Q9 to reflect Jan 18-Dec 18 The base date of 2019 orders in cells S9:ad9 to reflect...

Hi all, I would like to create a Drop Down List in cell “A1”, so that to choose any month and then to appear the data in the current Spreadsheet. Note that the months are belong to another file, named Cash Sales Table. In sch. 1. are the original data and in sch. 2. Is the expected result...

Hi, I require some help please. I am looking for an equation to that will sum based on multiple adjacent cells have specific terms. I need to total the revenue in row D for all lines that have a specific working in Row A B and C See example below: I need a formula to automatically calculate...

Dear All, How you all are fine and doing well. I have a query about Pivot. I have a huge date level data and based on the same I am creating pivots. Now I would like to compare MTD performance v/s last year. For example 01May-14May 2018 Revenue v/s 01May-14May 2017 Revenue. In pivot if I...

Hello - I have an OLAP pivot that needs conditional formatting. This pivot is a income statement at the account level. So the conditional formatting can be built at a hierarchy level for the pivot. In my case, I can built the formatting on "LEVEL 9" of the hierarchy. The problem is both...

Greetings! I am pretty new to vba and attempting to work through this problem as thoroughly as possible so any direction or help with be much appreciated. I have 3 worksheets that I am currently using: Sheet 1= "Table"- Which holds a list of profit centers (List is located in Range L3:L23)...

Hello, I am making an attempt at using VBA for the first time and it is not going well. I tried searching for help but I was getting confused when I try to modify to my own data. My goal is to copy data from the Customer Data tab and paste into the Revenue tab. I will need to copy a few...

I'm trying to extract specific fields from multiple sheets in to one sheet. Each sheet has multiple rows with row heading as ID, name, total costs, total revenue. I need to find the rows that have these headings. Then the value for each one is listed in different columns - like ID value is...

Hi there New user here! I am building a financial model and want a quicker way to spread the revenue. I have a monthly P&L going for 5 years and I have to spread the monthly revenue across 12 months in a separate tab. Source file: <tbody> Jan 17 Feb 17 Mar 17 till Dec 21 Monthly...

Hello, what is the best Excel formula to adjust for this shortfall? <colgroup><col><col><col></colgroup><tbody> Revenue Split Total Revenue $5,000 100% Agent (80%) $4,000 80% Broker (20%) $1,000 20% Minimum Broker Revenue $1,500 Agent Adjusted Payout ($4,000 - $500 = $3,500...

Hi, I'm in need of some help in creating a spreadsheet and graph for my business. I haven't used Excel since I left school so I'm a little bit rusty, but I'm a fast learner. I work in a pub with a large beer garden. I want to create a spreadsheet and line graph that show the relationship...

Hello, I followed EnterpriseDNA's dynamic instructions to recreate this dashboard from Decisive Data. I'm currently stuck trying to recreate TopX/BottomX in the filters. I can show Top 3, 5, 10, etc., but I cannot get the graph to display Bottom. My selection criteria are: 1st - Revenue and...

Hi any help on the below problem would be appreciated, alternatively if it's been answered elsewhere please direct me..... <tbody> Month Revenue LC Revenue GBP Invoice LC Invoice GBP FX Rate 1 2,000 1,333.33 1.5 2 0 0 1.75 3 300 150 2 4 2,100 ???? 0 0 1.25 5 300 ???? 0 0 1.75...

A - Client numbers (duplicates when applicable along different lines of business) K - fixed monthly number count per line of business The CAPS sheet is our monthly recurring revenue. I'm aiming to distribute that recurring monthly revenue across the (K) column IF A=duplicate paths. Having...

Hello, I'm trying to write a formula that excludes a set of values in sheet 1, in cells A1 through A5 I have Name 1, Name 2, Name 3, Name 4, Name 5. In sheet 2, in pivot table format I have hundreds of names in column A, in column B I have the corresponding revenue for each name, and in column...

Hi All! I'm looking for VBA code to copy and paste values in the range D37:F54 in the below example, but for only the rows that are not sub-totals (i.e. paste values for accounts that do not start with a "PL") Right now all rows have formulas in them that populate the data from somewhere else in...

Hi all, I'm trying to shade in between two lines one which is revenue and the other is cost over a period of time. Naturally they cross each other. So far I have been able to show one in black when in "profit" and in red when showing a "loss". However, when they move from profit to loss there...