Is there a way to use the lookup function to find a particular row and column and not just a row in the same partition? I can easily do this with the offset function Excel where I can go over 1 column and down x rows

tableaucommunity@tableau.com — Sun, 03 Nov 2013 13:46:40 GMT

Is there a way to use the lookup function to find a particular row and column and not just a row in the same partition? I can easily do this with the offset function Excel where I can go over x column and down x rows

I want to add the green colors and the blue. So 100+61=161 for green and blue is 100+60+51=211. I want these in different columns as well.

100	100	100
61	60
51

How do I average across rows and only show that average?

tableaucommunity@tableau.com — Thu, 27 Jun 2013 18:41:55 GMT

I am looking at data from a static perspective and I have a columns for dates and rows is how the old the user is. I only want to display the average. Example below:

Row Labels	6-May-13	7-May-13	8-May-13	9-May-13	10-May-13	11-May-13	12-May-13	13-May-13	14-May-13	15-May-13	Average Across
0	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%	100%
1	52%	52%	51%	50%	46%	52%	51%	51%	51%	50%	51%
2	41%	41%	39%	33%	36%	40%	39%	40%	39%	37%	38%
3	35%	34%	29%	29%	37%	34%	34%	34%	32%	28%	33%
4	31%	26%	27%	34%	32%	31%	31%	29%	25%	26%	29%
5	24%	25%	31%	31%	30%	28%	27%	23%	23%	29%	27%
6	23%	29%	28%	28%	27%	26%	26%	22%	27%	27%	26%
7	27%	27%	26%	26%	24%	25%	26%	26%	25%	26%	26%
8	25%	25%	24%	23%	20%	24%	23%	24%	23%	23%	23%
9	23%	23%	21%	18%	19%	22%	21%	22%	21%	20%	21%
10	22%	21%	18%	18%	21%	21%	20%	21%	19%	16%	20%
11	19%	17%	17%	21%	20%	20%	19%	18%	15%	15%	18%
12	16%	17%	20%	20%	19%	19%	18%	15%	14%	16%	17%
13	16%	20%	19%	19%	18%	18%	17%	14%	15%	18%	17%
14	19%	20%	18%	19%	17%	17%	17%	15%	18%	18%	18%
15	18%	18%	17%	17%	14%	16%	17%	18%	17%	17%	17%
16	17%	17%	15%	13%	13%	17%	16%	17%	16%	15%	16%
17	16%	15%	12%	12%	14%	16%	16%	16%	15%	13%	15%
18	15%	12%	12%	13%	15%	15%	15%	15%	12%	13%	14%
19	12%	12%	13%	16%	15%	15%	14%	12%	12%	15%	14%
20	11%	13%	15%	15%	15%	14%	13%	12%	14%	14%	14%

Content in Tableau Community Forums

Is there a way to use the lookup function to find a particular row and column and not just a row in the same partition? I can easily do this with the offset function Excel where I can go over 1 column and down x rows

How do I average across rows and only show that average?