Aggregation help

[hopkinsc]

Hi all,

I have another aggregation problem..

in the attached QVW i have 2 straight tables..

The top one is a summary by customer and the bottom one is a breakdown by customer, item and period.

The PVI expression in the bottom chart gives the correct number. I am trying to get the same number in the PVI expression of the top chart but i am struggling to get it working.

Can anyone help please?

[tresesco · Accepted solution]

Sum( {<Period={"<=$(=GetFieldSelections(Period))"}>} Aggr(

(sum({<Period={"<=$(=GetFieldSelections(Period))"}>}[Standard Cost])

-

sum({<Period={"<=$(=GetFieldSelections(Period))"}>}[Latest Cost]))

*

sum({<Period={"<=$(=GetFieldSelections(Period))"}>}[Sales Volume])

,[Standard Cost],Period,Item,[Customer Name]

))

[hopkinsc]

thanks very much!