Hi everyone,
I have 2 main inputs which are Forecast and Sales_orderlist, connected using master_cus, master_mat and calendar table.
I have added a new column in Forecast table to classified if given the date, is the data considered as forecast or actual (past data).
Then use a measure to calculate the value. If it is Actual, it will calcualte the sum of quantity in Sales_orderlist table, elseif it is Forecast, it will calculate the sum from Forecast table.
The output of the measure is shown in the top matrix
All values are as expected except the grand total of 16,578,623 which I see that it is calculated from the grand total sum of the quantity in the Forecast table as the numbers are the same shown in the matrix below it.
My expectation for the grand total is to be 17,584,000 as a sum of the total column.
