how to complete missing value pairs

[#1]

Hi Community,

can someone give me a hint how I can complete the missing value pairs? Unfortunately, I can't continue the Periode (month), because they are not included in [Periode neu] see image.

At the moment my diagram show only the months that correspond the same field  to [Periode] and [Periode_neu].

How can I show the missing months? In addition, should the missing values

be filled with 0.00 like this. See image

As a demonstration you can also to modifiy my attched qvw file.

Thank you very much.

[swuehl · Accepted solution]

Hi,

remove the Periode neu from dimensions and use this as expression:

=sum(if([Periode neu] = Periode,[Wert/Bwähr_neu],0))

Please see also attached.

Regards,

Stefan

[#3]

Hi swuehl,

I did not think that it makes a difference between sum(...if () ) and if( sum() ) !

Thank you very much