What we need is a calculation that always gives the total value of the sales of the skus appearing in the table (which changes as the user changes the parameter). For display we are getting it just by showing "column grand totals" but we need it as calculations as this dynamic number is needed as part of other calculated field for further analysis.
1 answer
The solution depends on the calculation used to create the original aggregation and the data structure which is why we like to see what you have done - please post your twbx workbook with at least some dummy data so we have a base to work from
thank
jim
