Set analysis to omit selection

[patrickbender]

Hi i would like to be able to get the total of both the rows using a set expression.

I tried to use :

=SUM({1}FSLEDGForeignCurrencyAmount)

But that destroys my current selections and all projects shows up.

I want to apply the "sum all" effect for the invoice level.

Hopefully someone understands what I try to accomplish.

[sunny_talwar]

What exactly are you hoping to see? Just one row with the value?

[patrickbender]

Yes that was the idea but couldn't do it without destroying the selection alternatives so I restructured the data.

Thank you for your time 🙂

[Vegar]

The SET analysis is considered for all dimensions in your table, to accomplish what you are trying to do you would need to use TOTAL.

=SUM(TOTAL <InvoiceNum>
FSLEDGForeignCurrencyAmount)