pivot column

[adamjwchen]

I have a pivot table like below. I would like to calculate the Margin$ difference of month 7 and 8, shows in the last column. How can I get the Margin$ value of month 7 and 8?

[balabhaskarqlik]

May be this:

Num(Column(1)-Column(3),'$###,###.00')

[vishsaggi]

May be by using dimensionality() function. Can you share your qvw file to work on if possible?

[adamjwchen]

I tried column() function, it does not work for this case.