Subaggregation

[#1]

Hi all,

Is it posible to make subagregation for example in table box?

I will need to have subtotal from vertical fields,

For example

Gross Sales                 1000

Quantity rebates           -100

Net I Sales                     900    As Subtotal from Gross Sales and Quantity rebates

Price Discount              -200 

Net Invoice                    700     As Subtotal from Net I Sales and Price discount

Is it posible to do in some other object in QV?

Thanks

[Gysbert_Wassenaar]

Yes and no. Qlikview is not a spreadsheet program. Trying to use it as one will be painful. But of course it is possible if you're not afraid to get hurt. See here.

[#3]

Gysbert,

Thank you very much, I think this will be very helpfull.

I will need time to digets all this :-)....

I have weekend for that.

Thank you very much again.

Greetings from Belgrade..

[#4]

Gysbert,

    I almost got it , but still have problem with blanks in P&L view, i only have it on the top of the P&L report.

It is strange because source table where the field 's' is stored have s an everything on right spot.

     So I put number in Profit and loss template table  and insert it in the report and hide, not so elegant solution but works.

Thank you very much again...