
1. Re: multiplication of a month value with a month by category value
Mark Holtz Nov 12, 2012 5:57 AM (in response to Kerem Tomak)Hi Kerem,
From what I can tell from your description, this should be possible.
Can you post a packaged workbook?

2. Re: multiplication of a month value with a month by category value
Kerem Tomak Nov 12, 2012 7:39 AM (in response to Mark Holtz)hi mark,
just uploaded the workbook
thanks

3. Re: multiplication of a month value with a month by category value
Mark Holtz Nov 12, 2012 10:11 AM (in response to Kerem Tomak)Oops... you'll need to make it a packaged workbook (file type twbx instead of twb)
Under the File menu, choose Export Packaged Workbook instead of Save As...

4. Re: multiplication of a month value with a month by category value
Kerem Tomak Nov 12, 2012 10:20 AM (in response to Mark Holtz)Darn, here it is. Thank you!

ISS v3.twbx.zip 163.1 KB


5. Re: multiplication of a month value with a month by category value
Mark Holtz Nov 12, 2012 1:43 PM (in response to Kerem Tomak)I'm not sure I got exactly what you want.
I've attached a file with a Calc3 field that multiplies the 2 fields on the FOB Adjustment tab.
Is this what you wanted to do?

ISS v3.twbx.zip 178.7 KB


6. Re: multiplication of a month value with a month by category value
Kerem Tomak Nov 12, 2012 1:56 PM (in response to Mark Holtz)No, currently there is a calculated field called Adjusted Store FOB on worksheet called FOB Adjustment. That is [multiplier]*[CIM Store Sales]. When you look at it on the worksheet, all its values are the same for the month of October but [CIM Store Sales] has different values for each FOB. I wanted to have Adjusted Store FOB to have the multiplier value for, say, october 2012, which is 0.0969, multiplied by [CIM Store Sales] and give a different [Adjusted Store FOB] for each FOB. right now, [Adjusted Store FOB] is 9.2544 for every FOB and total.

7. Re: multiplication of a month value with a month by category value
Mark Holtz Nov 13, 2012 5:28 AM (in response to Kerem Tomak)I'm wondering if it's just an unintended result of your formula algebra...
The formulas involved appear to be:
multiplier = StoreSales / CIMStoreSales
AdjustedStoreFOB = multiplier * CIMStoreSalesrewritten as:
AdjustedStoreFOB = (StoreSales / CIMStoreSales) * CIMStoreSales (A = (S/C) * C which yields A = S)
Are you not expecting AdjustedFOB to be equivalent to StoreSales, because by definition, it will be.
As your formulas exist now, since StoreSales is the same for each month, regardless of FOB, then so too will be AdjustedStoreFOB... 
8. Re: multiplication of a month value with a month by category value
Kerem Tomak Nov 13, 2012 7:27 AM (in response to Mark Holtz)well, multiplier is on a monthly total ratio. I want to apply that ratio to each category below CIMStoreSales equally, which will end up adding to the same total value but each breakout by category will be a different number. So, in above algebra for AdjustedStoreFOB, first CIMStoreSales is a monthly total, second CIMStoreSales is its by category breakout.

9. Re: multiplication of a month value with a month by category value
Mark Holtz Nov 13, 2012 10:47 AM (in response to Kerem Tomak)If your intention is to use a groupedlevel aggregation of CIMStoreSales in the multiplier formula, but to use a different groupedlevel aggregation in the AdjustedStoreFOB calculation, then that is where the problem lies.
Currently, the multiplier field calculates at whatever level is specified in the view.
You can prove this by dragging FOB onto the Rows shelf of the CIMMultiplier view. The multiplier there will calculate for each unique MonthFOB partition. If you want to "force it to remain" at the month level, you can use a table calculation.
Take a look at the attached workbook. Hopefully, we're closing in on the solution now!
ISS v3.twbx.zip 222.5 KB


10. Re: multiplication of a month value with a month by category value
Kerem Tomak Nov 13, 2012 1:04 PM (in response to Mark Holtz)YES!!!!! Thank you! This resolves the issue! I need to absorb this and if I have questions I will get back to you!. Table Calcs 101. Need training!

11. Re: multiplication of a month value with a month by category value
Mark Holtz Nov 13, 2012 1:22 PM (in response to Kerem Tomak)Mastery of table calculations remain a challenge still for me as well. I find it to be one of the most illusive topics regarding Tableau. It's abstract and confusing to me all at once...
Jonathan Drummey has put up some very good material about how to best learn what exactly table calculations are and how to make them behave. Here is a link to a wonderful resource he included on his blog.http://drawingwithnumbers.artisart.org/wanttolearntablecalculations/