Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
May be something like this -
RangeSum(above(Total sum(Sales),0,RowNo(Total)))
May be something like this -
RangeSum(above(Total sum(Sales),0,RowNo(Total)))
Thank you Digvijay!
Much appreciate your response