Lagging_Evol

suzel404 — Sat, 02 Sep 2017 09:06:45 GMT

Hi,

How can I calculate the lagging evolution: The evolution between H19 and H20 in % into crossTable.

H19vsH20 %

H20vsH21 %

H21vsH22 %

H22vsH23 %

H23vsH0 %

H0vsH1 %

H1vsH7 %

Thanks for your help.

Re: Lagging_Evol

Anil_Babu_Samineni — Sat, 02 Sep 2017 09:52:59 GMT

May be like this?

Script:

CrossTable(CalHour, HourSales)

LOAD Name,

[19],

[20],

[21],

[22],

[23],

[0],

[1],

[7],

[10]

FROM

(biff, embedded labels, table is Sheet1$, filters(

Remove(Col, Pos(Top, 2))

));

Report: