VB QlikView - Sum Function

[#1]

Hi guys,

I am trying to use VB in the QlikView. I have variable with field name, so as part of the code I want to sum all the values in this field.

This should be so simple (at least it is in VBA Excel), but I spent an hour on it and can't make it works...

Any Ideas?

Thank you.

Andrzej

[#2]

Thank you, for all your response.

Here is the Sample file. In real Data source I have about 100 columns, should I create 2 table to keep those years separately for Xtable? and most important hot to properly create it? I saw few post about this, but still don't completely understand it.

Thank you,

Andrzej

[#3]

Thank you all one more time. CrossTable does the work. Need to redesign some of the field I had in the Report it self, but this is the simple issue now.

Thank you.