5 Replies Latest reply on Jun 25, 2013 10:48 AM by Brad Llewellyn

# Transferring values from one sheet to another

Is it possible to calculate a value on 1 sheet then pull that value as a constant onto another sheet?  A small example is below:

Data:

Price     Quantity

1                 1

1                 2

1                 3

2                 4

2                 5

2                 6

Sheet 1:

Text Table

__________

Sum of Quantity |              21

Sheet 2:

Text Table

Price     |  Total Sum of Quantity (constant)

1           |                                           21

2           |                                           21

I realize that this case could be solved with a custom calculation.  However, the more complicated problem I am dealing with is not nearly so simple.

• ###### 1. Re: Transferring values from one sheet to another

Typically this is achieved with table calculations - in your case total(sum([Quantity]) may work. Without being able to see the real data and the additional complexity this is about as much as we can help.

• ###### 2. Re: Transferring values from one sheet to another

Thanks for your swift reply.  I agree that table calculations are probably the answer.  To word my original question more thoroughly, is there a way to store a constant in Tableau without having to hardcode it into the data set and retrieve it with a max() function?

• ###### 3. Re: Transferring values from one sheet to another

A parameter?

• ###### 4. Re: Transferring values from one sheet to another

I've stumbled on this problem too. I need to get the result from the other sheet (Table). And since this sheet is full of calculated fields I don't want to ruin everything. I just need to get the value of whatever month that I would select.

For Ex. In the new sheet, if I would select 2013 / 03 I will get:

 2013 / 03 86,000 64,600 -10% 161,511 36%

Table:

 YTD QTD Month Cost Total YoY Total YoY 2013 / 01 16,500 64,600 -10% 161,511 36% 2013 / 02 17,500 64,600 -10% 161,511 36% 2013 / 03 86,000 64,600 -10% 161,511 36% 2013 / 04 132,900 64,600 -10% 161,511 36%

• ###### 5. Re: Transferring values from one sheet to another

Camille,

One alternative would be to duplicate the sheet, and retrieve the value via a table calculation and/or quick filter.

Let me know if this helps,