topic Sum in a Pivot Table in QlikView

Sum in a Pivot Table

Tue, 03 Sep 2013 20:38:10 GMT

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

Re: Sum in a Pivot Table

rustyfishbones — Tue, 03 Sep 2013 21:27:14 GMT

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

Re: Sum in a Pivot Table

Tue, 03 Sep 2013 22:24:39 GMT

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,