Pivot Table / Above() Function Help

[#1]

Please could someone provide an example on how to create a pivot table like below?

The %change is calculated with the %above function.  I wish to place it below FY14 instead of as a column (i.e. to the right with the Wins column) and apply conditional format to all 3 cells (i.e. FY15, FY14 and %Change) if %Change is either >=0 (Green) or <0 (Red).

[israrkhan]

can you share A sample doc. will be easy to answer.

[#3]

Sample file attached

[SergeyMak · Accepted solution]

Hi Lawrence,

PFA

Regards,

Sergey

p.s: I calculated period based on its definition, but it would better to do based on calendar table

[israrkhan]

i was preparing it, and i saw you already got the answer...

Kind Rgards

Khan