Add column for %change

[Alma1234]

Hi there,

I need to add to the following chart 2 columns:

1) Feb-18 - Dec-17 Change in Sales

2) Change % (between Feb 18 and Dec 17)

Would like to get ideas.

Thanks,

[YoussefBelloum]

Hi,

is it a pivot table on the Image ?

[eliran]

Hi Limor,

How are you?

If it's indeed a pivot, you can't do it straight forward.. you'll have to add special values into the period dimension, and alter your expression to match the column.

Maybe try keeping it simple, add specific expressions for selected columns, and then add the two more columns, delta between the selected periods, and the %change.

Hope it helps,

Eliran.

[Alma1234]

Yes its a pivot

[Alma1234]

Hi Eliran,

Thanks for the reply.

I tried but since this value in the calendar doesn't connect to the other tables,

it creates an incorrect values.

Best Regards,