Forum Discussion
|| Dynamic Segmentation : The formula ||
Hi somnath6309 ,
That is refering to the the fact that you are using the values from the segment table within each row meaning that for each line you only have a single line if you took for example the Very Low you have min 0 maximum 75 this is what is going to be applied to the specific calculation and the result gets the exact result.
So the row context is coming directly from your segment table since you used it in your lines in the matrix visual and then applying that to the calculation.
Hi,
My question was not regarding the wrong grand total. We have to use SUMX if want the correct grand total. However the following version of the code works for every cell of the matrix other than the Grand Totals ( we can make it OFF from Visual options) :
Here, if we view the cells highlighted in RED in the below matrix, the figures 351, 302 are correct. ( see the below pic )
Now, the question is : when the code is executed without SUMX, how the row context is opened in the "Segments" table so that the MIN formula can access the Minimum Sale row by row ?
Regards,
Somnath
Hi somnath6309 ,
That is refering to the the fact that you are using the values from the segment table within each row meaning that for each line you only have a single line if you took for example the Very Low you have min 0 maximum 75 this is what is going to be applied to the specific calculation and the result gets the exact result.
So the row context is coming directly from your segment table since you used it in your lines in the matrix visual and then applying that to the calculation.