Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have a doubt, I'd like show a KPI the highest month in sales:
Year | Month | Products | Amount |
2017 | Jan | 24 | 88,800 |
2017 | Jan | 28 | 103,600 |
2017 | Jan | 34 | 125,800 |
2017 | Jan | 40 | 148,000 |
2017 | Feb | 24 | 88,800 |
2017 | Feb | 14 | 51,800 |
2017 | Mar | 80 | 29,600 |
2017 | Mar | 50 | 18,500 |
2017 | Apr | 30 | 11,100 |
2017 | Apr | 20 | 7,400 |
2017 | May | 10 | 3,700 |
2017 | May | 80 | 2,000 |
2017 | May | 95 | 40,000 |
2017 | May | 10 | 74,000 |
2017 | Jun | 15 | 3,700 |
2017 | Jun | 20 | 9,000 |
2017 | Jul | 30 | 12,000 |
2017 | Aug | 10 | 20,000 |
2017 | Sep | 40 | 14,800 |
2017 | Oct | 60 | 22,200 |
2017 | Nov | 12 | 44,400 |
2017 | Dec | 18 | 66,600 |
I'd like to answer 2 Question at least:
1.- What's the month with more sales (In Products)?
2.- What's the month with more sales (In Amount)?
What I'm looking for is a function to solve and get this one:
Top Products
May 195
Top Sales
Jan 466,200
In a textbox?
try something like
=Maxstring( Aggr( dual(Month & ' ' & Money(Sum(Amount)), Sum(Amount)), Year., Month))
=Maxstring( Aggr( dual(Month & ' ' & Num(Sum(Products)), Sum(Products)), Year., Month))
In a textbox?
try something like
=Maxstring( Aggr( dual(Month & ' ' & Money(Sum(Amount)), Sum(Amount)), Year., Month))
=Maxstring( Aggr( dual(Month & ' ' & Num(Sum(Products)), Sum(Products)), Year., Month))
Simply... You're the best, Stefan...
Thank you very much...
Kind Regards
Luis