Line chart, 2 dimensions, % by dimension

[Michiel_QV_Fan]

I need to show the relation in % for 1 dimension over time.

On the x axis I show time.

Jaar maand	Klant	Overig	Overig/Klant
2014-1	-75467	92983	-123%
2014-2	-66467	69255	-104%
2014-3	-65289	75750	-116%
2014-4	-67518	68635	-102%
2014-5	-79826	67569	-85%
2014-6	-55449	75806	-137%
2014-7	-60769	67175	-111%
2014-8	-73046	64482	-88%
2014-9	-61517	45214	-73%
2014-10	-46108	70902	-154%
2014-11	-88217	864	-1%
2014-12	-123808	147240	-119%

I need a stacked line chart over a second dimension and over time.

I have the %relation ship in this straight table with this expression for the month:

aggr(sum({<%C_code = {'1'}>} Mutatie),[Jaar maand] )/aggr(sum({<%C_code = -{'1'}>} Mutatie),[Jaar maand] )

But I can't find a way to show this in the line chart. Values are calculated over the total value selected and I need these for each month recalculated.

In the line chart:

Each month = 100%

C_code 1 is the divider

C_code <> 1 are the values to be divided.

[Gysbert_Wassenaar]

I'm afraid I don't understand what you're trying to do.

• What is a stacked line chart?
• You mention a second dimension. The data you posted seems to have only one dimension. Can you explain about this second dimension?
• What does "Values are calculated over the total value selected" mean?

[Michiel_QV_Fan]

Gysbert,

We changed the requirement to be able to show the data in a different way.

Regards