Please, try to help me with this, I have model data like this:
Tree tables associate by category field.
In my sheet a have figure where I can get sales by categories, with this expression: sum(salesA)+sum(salesB)+sum(salesC). that works! But now, I need a new figures group by Category & month.
In the tables, I set different names for months (montA,.monthB,monthC) fields to avoid creating a synthetic table, but those fields have the same values: January, February, etc. In the sheet I need to know Sales group by Category in January, February, etc.
How I can get this without create a synthetic table? is necessary to modify mi model or is possible to do directly from the sheet?