pivot table customization

[ali_hijazi]

Hello I got a pivot table with 4 dimensions D1, D2, D3, and D4

it also has 6 expressions

the first expression is supposed to be the YTD (year to date) summation of debit minus credit amounts

now since D4 is MonthYear I used the sum(aggr(sum(debit-credit),,D3)

now everything is just fine except that the first expression E1 is repeated foreach monthyear

however I only want this expression to appear once

is this possible?

thank you

[raghavsurya]

hi,

Can you pls upload a sample qvw file.

Regards,

Raghav

[ali_hijazi]

attached is the pivot table that I'm working on

Regards

Ali M. Hijazi

[ali_hijazi]

how can I send you a 155MB qlikview document?