4 Replies Latest reply on Mar 15, 2017 5:06 AM by Maria Trumble

# Profit Curve

I thought I was doing well with the set up of my product p&ls.  Managed a few charts that looked pretty and my manager throw me a "curve" ball.......

He would like me to set up a profit curve that appears in my dashboard.

I'm stumped.  I'm not even sure if it is possible

I have attached a spreadsheet to show the profit curve and how it is calculated in excel.

The key bit here is the actual line.  I have these numbers already within my tableau data.  The Sales and the Profit will change depending on how far I drill down in my data.  However the assumptions in excel, to the right, will stay the same.

Is there some fancy formula that can calculate these predictions

I have also provide a screen shot of my attempt.  Didn't really get very far.

Any help will be very much appreciated.  Even if it is to tell my boss he is reaching for too many stars

• ###### 1. Re: Profit Curve

Hi Maria

I attached a t10.1 workbook

the key is to put the profit and sales on rows and columns but do not aggregate them

Let me know if this helped

Jim

• ###### 2. Re: Profit Curve

Hi Maria

I don't know how you want to simulate max min, and median, bit anyways, I replicated your data by parameters and formula.

Parameter

[Profit Simulate]

if index()<=11 then

[Profit]+15+ first()*1.5

elseif

index()>11 then

[Profit]+(first()+10)*2.35

end

[Sales Simulate]

[Saels]+110-index()*10

Thanks,

Shin

• ###### 3. Re: Profit Curve

Hi Marie

You have to think I crazy I attached the right workbook but wrong visual

Jim