Forum Discussion
Solved
How to split columns and show units sold
I have one column showing vehicles sold and another column showing DD/MM/YY for when this vehicle was sold. I need to show how many of the same type of vehicle was sold in a year and a month. So...
first you need to create a date table, you can use =CalenderAuto for this.
create a relationship between the date table and the table of data
create a new table with a unique list of vehicles, you can use =distinct for this table
create a relationship between the vehicles table and the table of data
Next create a pivot table/visulaisation and drop in the date from the date table and the vehicle from the vehicle table and you can then use the count aggregation from the table of data in the values
v-ljerr-msft
Microsoft Employee
Microsoft Employee