Calculating total

[ccsimo16]

Hi

I have a spreadsheet which looks like

Supplier    Tier      Value     Rebate

A                1              100          1%

B                2            200          5%

C                1             50            1%

D                 2             300          2%

I can calculate each line with no problem by using

=sum (value) * sum(Rebate)

The problem comes when i want to total all rebate by Tier

Thanks

[prma7799]

Try like this

Test:

LOAD * , SubField(Rebate,'%',1)  as Rebate_New;

LOAD * Inline [

Supplier,    Tier    ,  Value     ,Rebate

A,                1   ,           100 ,         1%

B ,               2    ,        200    ,      5%

C  ,              1     ,        50     ,       1%

D   ,              2     ,        300    ,      2%

];

[ccsimo16]

Hi PM

Thanks for the reply, how would i write the Expression

Thanks

Chris

[marcus_sommer]

Try it with the following expression:

sum(aggr(sum(value) * sum(Rebate), Supplier, Tier))

- Marcus

[Anil_Babu_Samineni · Accepted solution]

Do you mean this?

=sum (TOTAL <Tier> value) * sum(TOTAL <Tier> Rebate)

OR

sum(aggr(sum(value) * sum(Rebate), Supplier, Tier))

[ccsimo16]

Thanks All Great Community as always

[Anil_Babu_Samineni]

You can mark proper correct answer

[prma7799]

Like this??

sum(Aggr(sum(value) *  sum(Rebate_New), Supplier, Tier))

[ccsimo16]

Hi Anil

it was  sum(aggr(sum(value) * sum(Rebate), Supplier, Tier))

How would i change to work as a dimension?

Thanks

[Anil_Babu_Samineni]

May be remove Sum(), Perhaps like below?

Aggr(sum(value) * sum(Rebate), Supplier, Tier)