Forum Discussion
Controlling subtotals formula in a Matrix
Hi Matt,
Sorry for late reply and thank you very much for your help!
Your formula allmost worked !
See below another more detailled example of my issue.
Let me know if you have any idea on how to fix it since your formula is working for 2 rows out of 5
Thank you in advance for your help!
Jerome
Community ChampionCan you also post an image of the visual with the formula I provided in place so I can see what that is returning
See enclosed.
Thanks Matt!
Jerome
See enclosed.
Thanks Matt!
Jerome
with the formula!
- MattAllington
Strange. 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