I have a pivot table where I have products, dates and the price for each date, I have products as rows, dates as columns and price as the main meassure, whenever I filter by date I am able to see columns for the selected dates instead of the full data set. I am wondering on how to create a variable or an extra column to reflect the percent change on the most recent date selected and the first dade selected. It would be only 2 dates as the price.
Thanks for the help