Subtotal when using XML data
 

I created a spreadsheet by importing XML data.

When i try to do subtotal under 'Data' menu it doesnt get highlighted.

Can't we use subtotal function when we import XML data??

Any suggestions to overcome this would be helpful

Thanks