
1. Re: Division  Rows in same column
Alex Kerin Jul 24, 2013 7:41 AM (in response to buildstar)You need to break [search] into two fields based on [test]

Sample.twbx.zip 20.3 KB


2. Re: Division  Rows in same column
buildstar Jul 25, 2013 4:07 AM (in response to Alex Kerin)Can I not use the existing field without adding a new field in the database table?
As it is I want to perform division and display in a new column

3. Re: Division  Rows in same column
buildstar Jul 26, 2013 12:51 AM (in response to buildstar)Tracy Rodgers  http://community.tableau.com/thread/125335
Similar to this computation but not getting correct values
IF INDEX() = 6 THEN (((lookup(sum([search]), first()+5)/lookup(sum([search]), first()))))/(lookup(sum([search]), first()))
ElseIF INDEX() = 7 THEN (((lookup(sum([search]), first()+6)/lookup(sum([search]), first())+1)))/(lookup(sum([search]), first()+1))
ElseIF INDEX() = 8 THEN (((lookup(sum([search]), first()+7)/lookup(sum([search]), first())+2)))/(lookup(sum([search]), first()+2))
ElseIF INDEX() = 9 THEN (((lookup(sum([search]), first()+8)/lookup(sum([search]), first())+3)))/(lookup(sum([search]), first()+3))
ElseIF INDEX() = 10 THEN (((lookup(sum([search]), first()+9)/lookup(sum([search]), first())+4)))/(lookup(sum([search]), first()+4))
END
Please help fix this calculation. I will display computed results next to rows 6,7,8,9,10 in new column.
Should I set compute using? If so to what can I set?
Thanks

4. Re: Division  Rows in same column
Alex Kerin Jul 26, 2013 7:21 AM (in response to buildstar)It's pretty ridiculous to do that when you have a simple solution that just requires you to rethink the way you display your data. The slightest change in the data will screw all of that up.

5. Re: Division  Rows in same column
buildstar Jul 26, 2013 7:25 AM (in response to Alex Kerin)Sure. But how do I approach the problem with the method I have been trying?

6. Re: Division  Rows in same column
Alex Kerin Jul 26, 2013 7:47 AM (in response to buildstar)Hopefully someone else has the time to do that.