I am trying to use your Summary Table and it has solved almost all the requests I have, but I have a problem with the formulas if the "values" I total in a formula is blank then the result is blank even if the total should be a value.
simplified example:
[Net Sales] = 100
[Cogs] = 50
[Contribution I]= 50
[Other costs] = blank or no values
Contribution II = blank - though it should result in 50
I am trying to use your Summary Table and it has solved almost all the requests I have, but I have a problem with the formulas if the "values" I total in a formula is blank then the result is blank even if the total should be a value.
simplified example:
[Net Sales] = 100 [Cogs] = 50 [Contribution I]= 50 [Other costs] = blank or no values Contribution II = blank - though it should result in 50