I have sales data with a unique customer ID on each row and their corresponding sales by Product on columns. I have a separate table for product hierarchy, which has a mapping of all products (column names) and the corresponding product hierarchy. I want to somehow pivot the original sales table within Tableau to return a table with Hierarchy --> Product --> some discount based on a Tableau calculated field. Is this possible with Tableau?

This is an example of the sales table:

Table of Sales By Customer

This is the product hierarchy cross-match. Prod 3 and 4 belong to the same hierarchy:

Hierarchy Cross Match

This is the final table I want to return:

Table with hierarchy, product and discount percentage based on Calc Field

Thank you for the help!


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.