complex analysis

[antosraf]

Hi

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 ?

BR

Rafal

HI

I have solved this

here it is

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