Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
RimDataAnalyst
Contributor III
Contributor III

Sum Range with a dimension

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 

RimDataAnalyst_0-1653940377987.png

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

Labels (4)
0 Replies