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.
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?
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%
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%
Thanks in advance!
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,