Pivot table calculations

[aetingu12]

Dear all,

Is there a way to add calculated columns on a pivot table? ie I have one dimension of products and one dimension of dates and an expression of sales.

The products are the first columns, dates are across on the top giving me the sales by date. On the very last columns following the latest date, I want to calculate a movement between the latest available date (in dimension) and the prior one.

So I would like to be able to show the historic sales plus the latest change.

Here is the code:

LOAD * INLINE [
    Product, Date, Sale
    A, 31/01/2019, 100
    B, 28/02/2019, 150
    A, 28/02/2019, 50
    B, 31/01/2019, 200
    A, 31/03/2019, 50
    B, 31/03/2019, 200  
];

Pivot table:

Ask is:

Is this doable?

Regards,

[shiveshsingh]

Please share sample data and expected output.

[aetingu12]

Just added an excel image to explain the output