
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Working with cumulative for Pareto
My data is has following cols
Country, State, Period(in mm/dd/yyyy format), Qty, Year
A, A1, 1/1/2015, 10, 2015
A, A2, 1/1/2015, 20, 2015
A, A1, 2/1/2015, 25, 2015
A, A1, 1/1/2014, 15, 2014
A, A1, 2/1/2014, 10, 2014
B, B1, 3/1/2015, 30, 2015
I want to achieve the following output
Year Country Sum(Qty) (for the Year) (in descending order) Cum Qty Cumulative % (at Year level)
2015 A 10+20+25=55 55 =55/(55+30)
2015 B 30 55+30=85 =85/(55+30)
2014 A 15+10=25 25 =25/(25)
Any help much appreciated.
Currently I achieve the above checking the Relative and Full Accumulation options.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Here is a different approach.
Create a straight table with dimensions Year and Country and first Expression
=Sum(Qty)
Sort your table first by Year desc, then by Sum(Qty) desc.
Add two expressions:
=rangesum(above(sum(Qty),0,rowno()))
=column(2) / Sum(Total<Year> Qty)
