I am using Excel 2010 and retrieving data from SQL analysis service.
When I refresh the data from Excel, the rows all refresh as they are bound to an external datasource. I am adding a separate column with a formula to sum the totals.
With an increment or decrement of these rows, the alignment of custom columns goes out.
How can I resolve this problem that summing of values become dynamic with adding and removal of rows?