Forum Discussion
Controlling subtotals formula in a Matrix
Community ChampionStrange. Which tables do your Market and Size columns come from? I can clearly see that the Size column has a value where there are blanks in the new formula, and this makes me suspicious
I have 4 tables with links:
Table 1: Volume by markets and size
Rows are showing different markets and within each market different product and within each product different size.
Columns are showing Markets/Size/Mths
Example
Row 1 : 123-Virginia/ABC-1000 10CL/ 10 qty
Row 2 : 123-Virginia/ABC-2000 20CL/ 50 qty
....
....
Table 2: Product Sales by markets and size
Rows are showing different markets and within each market different product and within each product different size.
Columns are showing Markets/Size/Mths
Example
Row 1 : 123-Virginia/ABC-1000 10CL/ $100
Row 2 :123-Virginia/ABC-2000 20CL/ $5000
....
....
Table 3: Size Master table
This table removes the size codes
Columns are showing Size Code/Size
Example
Row 1 : ABC-1000 10CL/ 10 CL
Row 2 : ABC-2000 20CL/ 20 CL
....
....
Table 4: Markets Master table
This table removes the Markets codes
Columns are showing Market Code/Market
Example
Row 1 : 123-Virginia/Virginia
....
....
hope this makes sense
- MattAllington
Sure, but which table does the SIZE column in your visual come from? Is it from the Size master table? It should be, but my best guess (without seeing it) is that this column is coming from a different table (just a guess)