07-06-2020 15:58 PM
Firstly thanks Greg for this great article.
when dealing with a measure that is in itself a sumx , is there something i need to do differently in creating the variable table?
the formula works for each month but total is returnign zero and i ssupect it is due to the sumx formula not creating the summarizes table correctly.
After looking at this a bit have developed an alterative solution:
i created an index column in the data table for the level of calculations i need ie Customer + Product+ Month
Then i created a new table summarising that column and linked the new table back to the data table.
Then in the sumx formula used the new table as the reference Sumx( new table (custProdMonthnum), calculations)
this means it forces the total column to do the calcs at the month level, so all adds up. also it means just one formula and doesnt worry if you add in qrtly totals etc..
I suggest you post your question as a new thread in the "Help" Forum. I don't think this thread should be used to ask questions for Help. You will get many more eyes looking at it which will assist you further.
Also please include as much detail as you can.
Good Luck and Best Regards,