Rangesum on mutiple dimesion
input table:
Load * Inline [
Name, Country, Sales
Pankaj, India, 100
Vikas, SL, 12
Raju, WJ, 10
Sujit, JH, 45
];
Output:
Name |
Country |
Sum(Sales) |
Rangesum |
Pankaj |
India |
100 |
100 |
Vikas |
SL |
12 |
112 |
Raju |
WJ |
10 |
122 |
Sujit |
JH |
45 |
167 |
I am using Aggr(RangeSum(above(sum(Sales),0,RowNo())),Country,Name)
@sunny_talwar can you please assist what I am missing