Hello ,
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])
thank you