deals

hi all. I have a table similar to; <tbody> Lead # Date In Referrer Sales Rep Customer Status 1 1/8/18 Company A AG Joe Blogs Active 2 14/8/18 Company A HB John Citizen Active 3 21/8/18 Company B AG Sherly Gray Dead </tbody> I'm wanting to have sheet 2 display on deals for...

Hello, I have a formula that calculates Deals 'Won'' as a % of Total Deals ('Won'+'Lost'). <tbody> =IFERROR((COUNTIF(Tbl_Deals_1[Status],"WON")/SUM(COUNTIF(Tbl_Deals_1[Status],"WON"),COUNTIF(Tbl_Deals_1[Status],"LOST"))),"") </tbody> It works fine, but I want it to only calculate for...

I'm trying to calculate commissions for my team. They get $100 per unit sold once they hit 9. But if its a half deal (.5) they do not get $50 instead. Only on full deals. example: 1-8 deals = 0 bonus 9 deals = $900 9.5 deals = $900 10 deals=$1000 and so on but with my formula 9.5 deals= $950...

Hi nd thanks in advance! I have created a Pivot Table My PT has a few row Fields in tubular form, Say 3 I have on columns a field named "Sales Stages" with up to 10 possibilities, for this eg, say this is always has 10 Fields or possibilities So At present My PT has 14 Columns + 1 "Grand...

I have a column that is closing date for deals, example 30-Oct-09. I need a column beside it that converts that to either a number for the month (10 for October) or simply enters the actual Month. I want to be able to sort all deals by month instead of yr.

Hi, I am currently working on a portfolio analysis model where I need to do a specific operation on multiple selected deals. My goal here is to be able to run the CALCULATE() on more than one selection. Currently I can do it with one selection in my slicer using the VALUES() formula. It...