Sub total value wrong for division measure in spotfire
In the below image. I am using cross tab for calculation.
For last column [Measure1/Measure2] column, the Subtotal value must be 467243.62 but I am getting rendom value. But for other two columns having the desired sub total value.
I need to consider the [Measure1/Measure2] subtotal for further calculation.
[Measure1] is sum of column1
[Measure2] is sum of column2
[Measure1/Measure2] is division of [sum(Column1)]/[Sum(column2)]
So, Please help me to get it resolved.
Thanks in advance.