I have two tables in one of my qlikview sheets, lets call them table 1 og 2.
In table 1, I have a column, lets call that for column A.
Column A is calculated upon the entire data load, and there for table 1 includes approx. 500.000 linies, and column A calculates a value for each of these linies. And I have added "total of rows" for column A.
Table 2, is ussed for management reports, and should there for show only the total sum column A in table 1.
Does anyone of you know how to make a formula, that on paper has the following function;