complex analysis

antosraf — Tue, 17 Feb 2015 09:41:30 GMT

I need you help

I use now straight tabe , also in pivot no success

it's what I need to do ,

expression; =sum([Mailing_time])*(Sum(tmp_AmtGroup)/Sum(TOTAL <[Country code]> tmp_AmtGroup))

the second column (PLK) is not needed but this is the lowest level I need to do the calulation visible in expression

then I need grouping on vendor level with sum of lower level calculations , like the last vendor now is showing 45 in fact should be sum of rows and result like ~ 30

in straight I can change Total mode and it's showing what I need but just on total total

I need this on subtotal (vendor ) level.

any ideas ?

Rafal

I have solved this

here it is

=sum(Aggr(sum([Mailing_time])*(Sum(tmp_AmtGroup)/Sum(TOTAL <[Country code]> tmp_AmtGroup)),PLK))

topic complex analysis in QlikView

complex analysis