Grouped Categories compared to total in a line chart over time

Janus Enevoldsen

November 09, 2023 08:57

Hi,

I'm trying to make a line chart that shows how certain categories develope over the years compared to total.

Hence: It always need to show four years back.

Below is a given example where I want Category1, Category2, Category3 grouped and compared to the total value of all categories.

I need a chart that shows:

1. The developement of the grouped total of categories and total values in one chart over the years.

2. The Percentage split between the grouped categories and total value over the years.

How do I make these visualizations in line charts?

2 comments

Jelle van Hulten
November 09, 2023 09:17 (Edited November 09, 2023 09:19)

Hi Janus,

I would do this as in image below. Create crosstab first with calculated columns. Then hide all columns except Category1-3, CategoryAll & %OfTotal. Finally, change cross tab to a line chart.

BR Jelle

1
Janus Enevoldsen
November 13, 2023 11:00

Hi Jelle,

Thanks for your reply - It will work.

0

Please sign in to leave a comment.