5 Replies Latest reply on May 30, 2016 4:34 AM by sushma.koyi

# If 2013 Sales numbers were expected to increase by 50% in the following year, what would be the total estimated sales for the Consumer Segment in 2014?

Does anyone have solution for this ?? Please share it with me.

• ###### 1. Re: If 2013 Sales numbers were expected to increase by 50% in the following year, what would be the total estimated sales for the Consumer Segment in 2014?

I'm guessing your [Enhanced Sales] is your estimated next year's sales? If so, try replacing your formula with SUM[Sales] + SUM[Sales] * 0.5  (or the equivalent: SUM[Sales] * 1.5).

• ###### 2. Re: If 2013 Sales numbers were expected to increase by 50% in the following year, what would be the total estimated sales for the Consumer Segment in 2014?

Hi Sushma,

Please find the attached screenshot which is giving you the desired result. Attached is the tableau 9.3 version.

Calculated that I have used -

1. "cal_2013_Consumer_Sales"

IF YEAR([Order Date])=2013 and [Segment]="Consumer" then ([Sales])

END

2. "Calc_Enhanced sales"

IF ATTR(YEAR([Order Date]))=2014 and ATTR([Segment])="Consumer" then SUM({EXCLUDE [Order Date]:SUM([cal_2013_Consumer_Sales])*1.5})

ELSE SUM([Sales])

END

i hope this helps.

Thanks and Regards,

Ashish Chaudhari

• ###### 3. Re: If 2013 Sales numbers were expected to increase by 50% in the following year, what would be the total estimated sales for the Consumer Segment in 2014?

You're calculated sales is showing same value for 2013 sales, which is wrong. Because, it's increase of 50 % in Sales value for 2013 itself..

You have got 2013 expected sales value to 2014 sales value.. Please check on that..

Data Set : Super store Sales from Tableau 9 Certification Preparation Guide.