Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to find out second lowest profit in the year and total profits till previous year
Anyone please tell me
use this min({<Year={'$(=max(Year))'}>}Sales,2) jus replaced max with min
max({<Year={'$(=max(Year))'}>}Sales,2) for second largest sale
sum({<Year-={'$(=max(Year))'}>}total Sales) - Total sale till last year
A:
load * inline [
Year ,Sales
2016,200
2016,700
2017,300
2017,200
2017,700
2017,800
2017,100
2017,560
2018,200
2018,500
2018,234
2018,456
2018,754
2018,897
];
exit script ;
use this min({<Year={'$(=max(Year))'}>}Sales,2) jus replaced max with min