Im trying to get the column value and set it as a variable

[#1]

For the growing accounts column i have the expression as =fabs(Column(8)='Growing') and for the total mode i set it to sum of rows

how am i suppose to retrieve 328 and set it into a variable

[vvvvvvizard]

=sum(aggre(fabs(copy expression from column 😎 , dimension 1 used in straight table , dimension 2..ect )

[#3]

erm sorry what do you mean by dimensions?

[#4 · Accepted solution]

Nvm thanks for the help bro i got it by using the macro

Sub Get_Growing_Accounts

Application.WaitForIdle

set cell=ActiveDocument.GetSheetObject("CH53").GetCell(1,10)

ActiveDocument.Variables("Get Growing Accounts").SetContent cell.text, True

set cell=nothing

End Sub