Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you very much.
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
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
Hi swuehl,
I did not think that it makes a difference between sum(...if () ) and if( sum() ) !
Thank you very much