Nprinting : Creating calculated columns in excel

[Anonymous]

hi everyone, i have a report that shows the daily revenue of fixed columns (last 3 days).

The table in qlikview formula is

Dimension : Type

Dimension : Date

Expression : Sum(Vol)

i would like to create a customized columns on F and G to get the sum and avg for the column C : E that is computed in qlik. how can i do this in nprinting?

level doesnt seems to suit me as i have some computation involve where i cant use table box.

[Anil_Babu_Samineni]

I believe you can do same in Qlikview and then you can work for N Printing to get desired view.

[Chanty4u]

you can try excel foramulae

in 3 row

=sum(cell1:cell2)    it will work

[Anonymous]

i tried. it doesnt give me any output.

[Chanty4u]

you need to take the extra cell   and add it in sum and try