Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Year 2015 2014
Cars Toyota Opel Mitsubishi Toyota Opel Mitsubishi
Okt. 10 20 30 10 40 50
Sept. 5 1 4 5 3 2
etc.
Now i want to totalize The specific cars.
see line total1
Year 2015 2014
Total1 15 21 34 15 43 52
Cars Toyota Opel Mitsubishi Toyota Opel Mitsubishi
Okt. 10 20 30 10 40 50
Sept. 5 1 4 5 3 2
etc.
How can i fix this?
This is easy, if you want to totalize, create a pivot table with Month, CarsTradeMark, Year as a dimension and an expression sum(unitsales). Pivot your table year and CarsTradeMark and that's it.
But If you want to see your data in that specific model, maybe you have to create an special mode to see your data, maybe creating anothe table with total only.