Total demand per item and month

[Anonymous]

I try to sum the total demand per item and month to prepare an ABC/XYZ analysis.

But unfortunately it doesnt work for all items.

Please check the attached example.

Thanks a lot for your help!

[sunny_talwar]

What exactly are you looking to get as an output?

[sasiparupudi1]

May be try rangesum

RangeSum(

Column(1),Column(2),Column(3),Column(4),Column(5),Column(6),Column(7),Column(8),Column(9),Column(10),Column(11),Column(12),

Column(13),Column(14),Column(15),Column(16),Column(17),Column(18),Column(19),Column(20),Column(21),Column(22),Column(23),Column(24)

)

use sum of rows to get the totals

[Anonymous]

I try to sum sales per item per month. This means that I need 24 partial sums for each item: one for each month and year

[sunny_talwar]

I am guessing that this chart is the problem

What exactly is not right in the chart? Can you highlight the incorrect numbers and tell us what exactly needs to be the right number?

[Anonymous]

Yes, the Sum column is calculated correctly. But the month columns sometimes show zero, sometimes show the right amount.

For material A it should indicate in october 2016 -1 piece, in march 2017 -1 and in december 2017 -6.

[sunny_talwar]

Check attached

[Anonymous]

That's great! How did you solve it?

[sunny_talwar]

Instead of using this as expression

=if(Buchungsmonat='1' and Buchungsjahr='2016',[Menge in ErfassME],'0')

use this

=Sum({<Buchungsmonat = {1}, Buchungsjahr = {2016}>} [Menge in ErfassME])

I also attached the qvw back with my response above for you to take a look at

[Anonymous]

Works perfectly! Thank you very much!