sum part of a row in pivot table

[#1]

Hi , i'm new to QV but i'm trying my best.

In my example i need to create 2 new columns that would sum the expressions "Local Amount" and "Remmitance Amount".

Is that possible and if yes, what is the syntax?

[yasus]

A simple "+"-operation should work

=sum([Local Amount])+sum([Remmitance Amount])

[#3]

Thanks Gregor but it seems that i didn't explain myself correct.

I need to sum in a new column (in my example) the [Locale Amount] (Expression)of CBMS and CBMS-PayPal which are diffrent merchants(Dimention). the same thing i need to do to the [Remmitance Amount]

I actually sum(Locale Amount] in its dimention anyway.

Thanks,

Avishay

[#4 · Accepted solution]

Try this:

=sum({<merchants={'CBMS','CBMS-PayPal'}>}[Local Amount])+

sum({<merchants={'CBMS','CBMS-PayPal'}>}[Remmitance Amount])

[#5]

Thanks you very much, it helps.

One more thing. CBMS and CBMS-PayPal can be anything else from the DB which means that the report don't know the merchant names.

Is there any generic formula for this?

[#6]

Try this:

=sum({<merchants={'*'}>}[Local Amount])+

sum({<merchants={'*'}>}[Remmitance Amount])

This will Consider all the merchants from the database.