0 Replies Latest reply: Feb 14, 2017 6:43 PM by Omar Morales RSS

    Percent Change based on dates on filter panel

    Omar Morales

      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