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))