Unique count data based on values with pre-filtering

[m156]

My raw data table contains customer data including: Customer ID, Countries, Date, Categories, Sales, etc.

Examples:

#123, US, Jan, Apple, $100

#123, UK, Jan, Orange, $200

#234, US, Feb, Apple, $100

#345, UK, Feb, Grape, $300

Is there any chance in one table, displaying the categories in the rows:

Calculating the percentage of customers (unique count) who buy any other Fruits from the group of customers (unique count) who buy Apple?

And then the same go for Orange, Grape, etc. on the same table.

I would like the table to be able to work with the slicer filter on the page so that I can filter things like Country, Date, etc.

Thank you very much for the help!

[williamdavi2]

Before analyzing data, it's crucial to ensure accuracy by pre-filtering and removing duplicates. Unique count data based on values offers insights into distinct occurrences, aiding decision-making processes. verizon business internet Through systematic pre-filtering, redundant entries are eliminated, enabling precise data analysis. This approach enhances data quality and integrity, facilitating more informed conclusions and strategic actions.

[Ritaf1983 · Accepted solution]

Hi @m156 
Ii sounds like basket analysis please refer to the linked tutorials:

https://www.youtube.com/watch?v=3OlZuXH9Y_g

https://www.youtube.com/watch?v=Wc08K6IWgIM

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly