2 Replies Latest reply on Jan 9, 2019 6:13 AM by Francheska Cabrera

    Calculation Issues in Price Gaps Segment Changes (10.5 Tableau Version)

    Francheska Cabrera

      Hello,

       

      I wish someone can share their knowledge with me as I have encountered an issue in a calculation for a price gap.

       

      I was able to calculate them, but when price segment for the brand family changes, the calculation goes wrong.

       

      I'm attaching a tableau workbook with the data and graph in version 10.5.

      Also I'm attaching the excel used as a source, there's a restraint to it and is that the format cannot be changed as it is extracted likewise from a system, my only option is to pivot it in Tableau which is not an issue.

       

      Below please see a detailed picture with the issues I'm having in 2 brand family changes.

      MOCKUP PRICE GAP FORUM TABLEAU.png

      Thank you for the help in advance.