Sum of Rows in Text Box

[#1]

Hi ,

Is there anyway to replicate the Sum of Rows in a Straight chart into a Text Box.

The problem I am facing is,the Total of an Expression is different when you individually calculate the expression for each quarter.

Any help would be greatly appreciated

[Gysbert_Wassenaar]

You can use the aggr function: sum(aggr(sum(Something),Dimension1, Dimension2, ...etc)

[maxgro]

try

=sum(aggr(sum(unitPerItem

*

[Unit Price] *

[Rejected Items]), Date))

[sunny_talwar]

Gysbert - Isn't that the same thing as Sum(Something) unless you have a distinct -> Sum(Aggr(Sum(DISTINCT Something), Dimension1, Dimension2, ...etc)

[#5]

I tried that,its not working in my case,wit the above example following expression is used in the text box.

=(sum(aggr(sum({<Test-={'Actual'},BrandId=p(DealId)>}CostPerBundle),Quarter,Id))/

sum(aggr(sum({<Test-={'Actual'},BrandId=p(DealId)>}TotaUnits),Quarter,Id)))

*sum(aggr(sum({<Test={'Actual'},BrandId=p(DealId)>}Rejected Items),Quarter,Id))*

sum(aggr(avg({<Test={'Actual'},BrandId=p(DealId)>}unitPerItem),Quarter,Id))

[sunny_talwar]

Give this a try:

=Sum(Aggr(

((Sum({<Test-={'Actual'}, BrandId=p(DealId)>} CostPerBundle)/Sum({<Test-={'Actual'}, BrandId=p(DealId)>} TotaUnits)) * Sum({<Test={'Actual'}, BrandId=p(DealId)>} Rejected Items) * Avg({<Test={'Actual'}, BrandId=p(DealId)>} unitPerItem)),

Quarter,Id))

[Gysbert_Wassenaar]

It depends on the Something.

[sunny_talwar]

So you mean if it is field or a bunch of calculations (like in his case a division and multiplication)?

[#9]

Thanks Maxgro.....it worked well when I am just using the tree fields,but when I use the Set Analysis condition for all the three fields its not working.

Any help

[sunny_talwar]

Did you try this John?

=Sum(Aggr(

((Sum({<Test-={'Actual'}, BrandId=p(DealId)>} CostPerBundle)/Sum({<Test-={'Actual'}, BrandId=p(DealId)>} TotaUnits)) * Sum({<Test={'Actual'}, BrandId=p(DealId)>} Rejected Items) * Avg({<Test={'Actual'}, BrandId=p(DealId)>} unitPerItem)),

Quarter,Id))