Data Analysis - Trend Analysis, Conditional formatting, Matrix/Table Chart counts.

[abhishek_2593]

I have a dataset of Products that are listed in various websites(Own Website, Amazon and Others) and is marked as present with '1'.
1. I want to analyse this data to check the number of unique products present in these website(basically the count of products in each of these sites and the combinations too).

a. Own Website(not necessarily all products to be listed in own website).
b. Amazon.
c. Other websites

2. Visually represent the products/count of products which are present in combination of these webistes(for ex: Own Website+Amazon,Own Website+Others,Others+Amazon etc.,)

3.Count of Unique Products listed in all the 3 categories of websites.

Can someone please help with this, also please let me know if additional info is required.

Thanks in advance!

[Anonymous · Accepted solution]

Hi @abhishek_2593 ,

The results are as follows.

You can download my attachment for more details.

Best Regards,

Stephen Tao

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

[CNENFRNL]

Simple enough, unpivot Amazon, own site, other sites columns to slice and dice the dataset.