Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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.
Please, do not duplicate questions:
A trellis is a good option but I should use a pivot table because the large amounts of brands ...
Use Pivot Table