Pivottable to diagram (rangesum)

[#1]

Hello,

I have two problems with the visualization of a forecast - diagram.

The first one:

In the pivottable everything is correctly. Here I'm using following formel:

Rangesum(Before($(vAVG)/10 ,0,ColumnNo())))

In the diagram I'm using this formel and it shows me only the exist months:

if( Month<month(Today()), sum( $(vStd)),

Rangesum(Before($(vAVG) ,0,ColumnNo()))

)

The second problem, if I set the filter on Technology, for example "BI", then I get no values for the future month in diagram and also pivottable.

Can you please help me.

[#2]

Thank you very much !!! No, it was no question, it was additional information ! Kind regard, André

[sunny_talwar]

Awesome

I am glad we were able to help you andrekab‌