Forum Discussion
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 if we sold 3 Pajeros in January 2017 - i need to have a column for 2017 and showing those units sold for the year for that specific vehicle
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
2 Replies
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
