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



      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.


      Thank you for the help in advance.