Forum Discussion
Running Total
- 10 years ago
I wrote a blog post today about how to create a Pareto Cumulative Running Total
http://exceleratorbi.com.au/cumulative-running-total-based-on-highest-value/
Paste in the exact formula you tried..?
sorry jahida,
i typed it wrong now there is no errors with formula but Running totals increased from 100% to 100.05% for every item in the Table.
here is what i did, as you said
First i chnged,
TotalGS = CALCULATE(SUM('Fact'[Gross Sales CY]),ALL(DimItem[ItemNumber]),ALLSELECTED(DimItem))
and then
RunningTotal = SUMX(FILTER(CALCULATETABLE(SUMMARIZE('Fact',DimItem[ItemNumber],"Contr",[GSContribution]),ALLSELECTED(DimItem[ItemNumber])),[Contr] >= MINX(VALUES(DimItem[ItemNumber]),[GSContribution])),[Contr])
Note: ItemNumber is different column and ItemKey is different column in DimItem
I have Itemkey in both Fact and DimItem on which i have joined.
ItemKey is Unique and ItemNumber can repeat
DimItem Ex: ItemKey ItemNumber Company
1 101 A
2 101 B
3 101 C
Does this fact have any effect on the formula
Please help me. Try to look at the image i am getting 100.05% now
- Anonymous10 years agoNot applicable
Anybody there...!!!:smileysad: