# Sub total value wrong for division measure in spotfire

Dear Friends,

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.

+ Add a Comment