Analysis 2.0 add excel formula between BW hierarchy
I created a BW query where we leverage GL accounts hierarchy from ECC.
Users have the ability to expand the node within the hierarchy. Now, we want to add a formula for example Net Revenue minus COGS between the hierarchy. In 2.0, we insert a row by clicking on new cells icon. But the excel formula we set is gone after refresh. Is there a workaround to have the excel formula there after refresh? Thank you very much for your insight.