sum in pivot table

[fsimoes81]

Change the expression adding "Month"

Sum(TOTAL<[Store No_], Month>Payment)

[tyagishaila]

Wow..

Its working,

Thanks Fabio.

Shaila

[tyagishaila]

Could you solve my one more problem?

In place of Total in %, Can I show Sum in numbers?

means Sum(Payment),

Don't show sum(payment) 2 times (each for Loyality & NoLoyality),

Only show sum of( Loyality & NoLoyality) 1 time.

[tyagishaila]

Could you solve my one more problem?

In place of Total in %, Can I show Sum in numbers?

means Sum(Payment),

Don't show sum(payment) 2 times (each for Loyality & NoLoyality),

Only show sum of( Loyality & NoLoyality) 1 time like

Loyality           NoLoyality          Total

Sum(%)           Sum(%)              Sum in numbers

Re: sum in pivot table

[tyagishaila]

Could you solve my one more problem?

In place of Total in %, Can I show Sum in numbers?

means Sum(Payment),

Don't show sum(payment) 2 times (each for Loyality & NoLoyality),

Only show sum of( Loyality & NoLoyality) 1 time like

Loyality           NoLoyality          Total

Sum(%)           Sum(%)              Sum in numbers

[fsimoes81]

Yes, move de expression at calculated dimension to script creating a new field

if([Loyalty Card No_]<>'','Loyality', 'Noloyality')                    as [Loyalty Card Type]

Then use that field on table

[tyagishaila]

No effect,

Result is same, sale column appears twice.

[fsimoes81]

Sorry. I understood what you need now.

The bad news is, it's not possible to do with pivot table.

[tyagishaila]

Ohhh,

Then, What should I use, Is it possible in straight table?

On Fri, Dec 12, 2014 at 6:45 PM, Fábio Simões <qcwebmaster@qlikview.com>

[fsimoes81]

Yes, using straight table, you can create your own colluns, format the Total columns. The problem is, you need to create all collumns one for month.