Which sheet object should I use?

[#1]

Hi, I'm experimenting with QlkView object and trying to decide which one to use for this type of table.  I will need calculate the values of several of these columns.  Thank you.  Jim

month_date	balance	roll off	roll off wac	roll on	roll on wac	ending balance

v

[erichshiino]

Hi, JFrancisco.

You should use a straight table. Eventually, a pivot table. It will depend on your data, if you want to let the user dinamically sort the columns (only available for straight table), etc

Hope this helps,

Erich

[#3]

Thanks Erich!  yes I've moved on to a pivot table.  I've created a field in my load statement "RollOnOff" which will allow me to sum up bals rolling off and bals rolling on.  However, when I put it in my pivot table, it only shows what's rolling off and on if I pick one or the other.