
1. Re: Aggregate Lookup Values
Yuriy Fal Apr 3, 2017 12:22 PM (in response to gerald.chee)Hi Gerald,
The problem you're trying to solve
(not getting the result you want
using the particular pills layout) is twofold.
First, the [AdjTotalWeeks] calculation
draws 1s on the additional densified Marks 
your data has no rows for that particular
combination of the dimension values on a view.
So one opt to use Table Calculations to draw this Marks,
and it should be another (nested) Table Calculation
to sum up the numbers across these Marks.
In your case it would be as simple as that:
WINDOW_SUM([AdjTotalWeeks])
Compute using > your_time_dimension
(those with Tn values on Columns).
But here comes the second complication:
Grand Total calculations (Tableaugenerated ones)
don't take into account densified Marks on a view.
And there is no way (as far as know) to make them aware.
So even if one have the "right" calculation for totals,
the result could not be placed in the (Grand) Total cell.
The solution? A sort of  to combine the desired "table" layout on a dash.
Please find the attached version 10.0 workbook as an example.
Hope it could help understand the problem better.
Yours,
Yuri

test_YF.twbx 1.2 MB
