Trying to Group Months into Columns With Data Underneath

Question

Hello! Is there a way to make the months into columns with a count of the data listed underneath? I tried using cross-tab, but it only adds one of each, whereas I want to keep all the data in columns one and two. Example below:

Original Data

Column 1    Column Two   Column Three

Month          Name             Inbound

April             Ikea                Inbound

April             Aldi                 Inbound

June            Disney            Inbound

June            Ikea                Inbound

January       Disney            Inbound

March          Disney            Inbound

March          Disney            Inbound

What I am after:

Column 1    Column 2      Column 3     Column 4    Column 5

Name           January         March            April             June

Disney          1                   2                     0                  1

Ikea              0                   0                     1                  1

Aldi               0                   0                     1                  0

AshleyL · Accepted Answer

HI @Melibau --

You'll want to use the CrossTab functionality here! I created an extra column so we can get the count on how many times the Name was repeated for the month!

If this is what you were looking for, make sure you mark it as a solution!

Best,

Ashley

vizAlter · Accepted Answer

Hi @Melibau  — Hope attached the solution will be helpful, if not let me know.

Two ways to achieve the same output:

If it resolves your query please mark it "Solved" or "Solved" with a Like. This will help other users find the same answer/resolution.  Thank you.