How show highest month with more sales

luisdarwinqlik — Fri, 09 Feb 2018 20:28:40 GMT

Hi there,

I have a doubt, I'd like show a KPI the highest month in sales:

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

Re: How show highest month with more sales

swuehl — Fri, 09 Feb 2018 20:56:52 GMT

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))

luisdarwinqlik — Sat, 10 Feb 2018 02:42:07 GMT

Simply... You're the best, Stefan...

Thank you very much...

Kind Regards

Luis