Row Total in a pivot

[Anonymous]

Hi

I have a data set below in excel and i would like to get the Total based on the Payment Status displayed in Qlik View through a pivot.

Sales Number	Personnel	Sales Amt	Payment Status	Total
AAAAA	Ankle	75	Paid	75
BBBBB	Arm	50	Due	50
CCCCC	Hand	24	Paid	24
DDDDD	Fin	20	Paid	20
EEEEEE	Plank	30	Due	30
FFFFF	Hill	45	Due	45

I have attached the QlikView Output which I am unable to get the Total in a new column on its own on the extreme right.  Is there anyway I am doing it wrong?

[prma7799]

You want like this???

[ahaahaaha]

Hi,

May be as in attached file. You can use flag "Show partial sums"

Regards,

Andrey

[#4]

Check the attachment, if you are looking r something like this.

[Anonymous]

Thanks,

I am unable to open forums qvw. Are you able to give a brief screen shot or the formula ?

[Anonymous]

Thanks

I am unable to open qvw attachments in forums, are you able to provide the screen shot or formula?

[Anonymous]

Thanks Andrey..

It worked..appreciate it