separate values in a table

[#1]

Hi best friends!

I would like to create diagrams for each car brand for themselves and it should show a TOTAL value for each year , but the must important thing is to separate the brands so each diagram shows a single car brand with TOTAL & YEAR.

[Anonymous]

you can define Trellis (e.g. barchart: tab Dimension, button at bottom) for your Dimension brand

in straight table you get a table per Dimension (brand and year)

[#3]

Hi,

According to my understanding Pivot Table should fits your requirement,

where Car brand & year as dimension.

if not please give more explanation and sample output.

[Anonymous]

Please, do not duplicate questions:

calculate per year

[alexandros17]

A trellis is a good option but I should use a pivot table because the large amounts of brands ...

[Kushal_Chawda]

Use Pivot Table