Sum in a Pivot Table

[#1]

Folks,

     I facing some problems to sum a value in a pivot Table.

    Sumary : I have dimensions from a table "A" and I need a expression that should sum values from table "B" that has an attribute "Z", applying a filter "A".dimension = "Z"  

     Please, see attachment with detailed explanation about my needs.

     I really appreciate any help !

Thanks in advance,

Gutemberg

[rustyfishbones]

You can try it like below, which is based on your tables 1 and 4 from the excel spreadsheet you provided

I hope it works for you

[#3]

Hi Alan, thanks for your answer. but,  i can't do it due to I've already done the conections as shown in the model and it would be cicle connection

regards,