Skip to Content
0
Former Member
Aug 17, 2017 at 05:04 AM

Analysis Office - New cells with excel formula

2679 Views

Hi All,

Am using Analysis for Office 2.4 and Excel 2013.We have a strange issue for below scenario.

1. Inserting New line juts after the dimensions.

2. Fill it with a very simple excel formula ex: referencing the member of dimension in column A1.

3. Using 'drag' option to copy the formula to all cells of a newly created column.

I am expecting the other cells of a column should refer to the correcting value of Dimension member like from A2, A3, A4 etc.. But it actually copying A1 value to all cells of newly created formula.

I do not have this issue if I create a excel formula using 'Measures' in Analysis Office.

It exists only with 'Members' data both key and text.

Please advice, is it a known issue with Analysis Office or am I missing anything here?