calculate variations in homologous period

[#1]

Hi,

I need to show in a straight table the top of clients with major reduction of, for instance, number of quantities ordered on at least two consecutive periods (month/year periods).

Anyone can help me to do this in Qlikview?

Many thanks

Best Regards

Paulo

[MarcoWedel]

please post some sample data and your expected result

thanks

regards

Marco

[#3]

Hi,

I'm trying to rephrase and simplify the question.

Considering the sample data attached, my expected result is to obtain:

-Top of the Clients that have a reduction on quantities in at least two consecutive months in comparison with homologous period.

-Top of the most relevant Clients (in percentage) face to the total of quantities ordered along the year.

Thanks in advance for your help on this.

Best Regards

Paulo

[#4]

Hi Mark,

Do you have a chance to look at this topic?

Thanks

Paulo