Forum Discussion

jcasqueiro's avatar
jcasqueiro
Brass Contributor
Mar 13, 2020

Replicating a column based on the content of a cell (that acts like a filter)

Hi,

I have a table with monthly values like:

 

jan   feb   mar

2       3      2

4       5      6

 

and I want to add a column that replicates one of the monthly cols based on a cell with the corresponding month, let's say D1.

If I put "jan" in D1, I would like to have column tot = column jan

                         jan

jan   feb   mar  tot

2       3      2       2

4       5      6       4

                         feb

jan   feb   mar  tot

2       3      2       3

4       5      6       5

 

I can accomplish this with Table1[@jan] for instance but how can I change the formula Table1[@month] to reflect the month that I put in D1?

 

Thanks/Brgds

j

3 Replies

Resources