Calculation for base level entity, Roll up at parent Level
We have a cube view with Entity Hierarchy in rows displaying values in local currency at the base level and USD at parent level. columns are CY Amount, PY Amount, Variance, Variance %, Currency Change Note - Currency Change is always reflected in USD...