i have this table to represent the and i want to calculate the cumulative sum of Round(KPI1*KPI3/KPI2) by the couple (growth axis , Merket segment name) : here is the table
and the formula of (KPI1*KPI3/KPI2) :
( [Market Value Driver % spread.% spread]*[Market Segment values.(parameter) b$ estimated digital part (Market Value)]*1000) *(Aggr(NODISTINCT Sum([Product Fleet volume.Fleet Volume] *[Growth axis topic % spread Product.% spread by value axis]),[Growth Axis - Name],[Market Value Driver - Name]) )/sum(total [Year Fleet volume.Fleet Volume])