Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want a value to be repeat in a column. So in my table below, I want for the value for Min Month (ie Aug 16) which is 6 092 970 to be repeated in another column. (See 2nd table below for ideal answer).
For simplicity, My dimension is Calendar Month and my Expression is Sum(Sales).
Please note that Min Month is dynamic and not specifically relating to Aug 16
Kind regards
Nayan
Calendar Month | Sales |
Aug-16 | 6 092 970 |
Sep-16 | 6 862 879 |
Oct-16 | 6 530 097 |
Nov-16 | 6 673 340 |
Dec-16 | 6 219 913 |
Jan-17 | 6 598 741 |
Feb-17 | 6 280 318 |
Mar-17 | 6 725 122 |
Apr-17 | 6 395 875 |
May-17 | 6 460 487 |
Jun-17 | 6 616 062 |
Jul-17 | 6 426 271 |
Total | 77 882 076 |
Ideal Answer
Calendar Month | Sales | Lowest Month Sales |
Aug-16 | 6 092 970 | 6 092 970 |
Sep-16 | 6 862 879 | 6 092 970 |
Oct-16 | 6 530 097 | 6 092 970 |
Nov-16 | 6 673 340 | 6 092 970 |
Dec-16 | 6 219 913 | 6 092 970 |
Jan-17 | 6 598 741 | 6 092 970 |
Feb-17 | 6 280 318 | 6 092 970 |
Mar-17 | 6 725 122 | 6 092 970 |
Apr-17 | 6 395 875 | 6 092 970 |
May-17 | 6 460 487 | 6 092 970 |
Jun-17 | 6 616 062 | 6 092 970 |
Jul-17 | 6 426 271 | 6 092 970 |
Total | 77 882 076 |
Then it could be this assuming that your month is has a Dual value in the script
Sum(Total {<[Calendar Month]={$(=Min([Calendar Month]))}>} Sales)
I hope this helps,
Luis
FirstSortedValue( Total Aggr(Sum(Sales), [Calendar Month]), [Calendar Month])
Hi,
I would have thought of something like this:
$(=Min(Aggr(Sum(Sales),[Calendar Month])))
Is the value in red the lowest monthly sales, or is it the monthly sales of the oldest month?
Cheers,
Luis
Hi Treseco
Thank you for your reply. I've applied your formula, however I get a blank.
Kind regards
Nayan
Hi Luis
Thank you fro your reply.
It is the sales of the oldest month.
Kind regards
Nayan
Then it could be this assuming that your month is has a Dual value in the script
Sum(Total {<[Calendar Month]={$(=Min([Calendar Month]))}>} Sales)
I hope this helps,
Luis
Thank you Luis. It worked.
Kind regards
Nayan
PFA...