good day - I am creating a pivot table from this select statement.
SELECT
date,
product,
market_value_1,market_value_1 as growth
FROM
report_combined
the pivot works 100% as per the example.
but now i need am stumped. as I need to work out on a new line or nect to it the growth, so column 20 - 19 /20
how will i be able to achive this?