2
$\begingroup$

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!

$\endgroup$

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.