How to turn a dimension in the same table?

[#1]

Hi,

I've encountered a problem I can not solve and need some help!

I have the dimensions "From Destination" and "To Destination". I use this to calculate the number of tons between differents locations, with the expression sum(tons). But, I need to turn this expression to how many tons who are sent back along the same line in return.

In other words, I must fetch up the "To Destination" and make it calculate this as an "From Destination". I tried to use SET expression like Sum({$<[From Destination] =  {[To Destination]}>} Tons), but it returns only zero...

Is there anyone who can help with some suggestions here?

///Tom

[#2]

From destination	To destination	Tons
Oslo	London	20000
London	Oslo	10000

This is what the end result should look like:

I have on dimension for Tons, From and To. When you choose From, the amount of tons sendt to the To destination  will be showed. I need to turn this this, sow the T"To destination" will be the same as the "From destination". That way I will get the retured tons on the same transportation line.

From Oslo to London 20 000 tons - Returned  (London - Oslo) 10 000 tons.

The problem is to get QV to understand that the calculations of the returned (10 000) need to pick the "To Destination" and use it as a "From Destination"....

That's why i tried:

From Oslo to  London: Sum(tons) - From London to Oslo: Sum({$<[From Destination] =  {[To Destination]}>} Tons)

///Tom

[ankitaag · Accepted solution]

Hi Tom,

Finally !! so glad to do this.

Kindly find the attached app.

Final result is exactly what you want.

Hope this is correct and helpful!

Thanks and Regards,

Ankita

[#4]

Hi,

This is exactly what I need! I'm very impressed!!

Thank you!!!

This solve my problem.

///Tom

[ankitaag]

Thankyou so much