I need to be able to resolve the following equation to know the dimension in the pivot table automatically.
I need to take out VehicleGroupName={'DimensionName'}>} and havr it automatically respect the dimension in the pivot table.
Count({<Inv={"=sum({<VehicleGroupName={'DimensionName'}>}aggr(exp(sum(log(1+Value1)))-1, VehicleGroupName,Inv))
<
(exp( SUM( TOTAL<VehicleGroupName, BusinessDate> aggr(log(1+SUM({<VehicleGroupName={'DimensionName'}>}PValue2)
/SUM({<VehicleGroupName={'DimensionName'}>}PValue3))
, VehicleGroupName, BusinessDate)))-1)"
}>} Distinct Inv)