Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Change the expression adding "Month"
Sum(TOTAL<[Store No_], Month>Payment)
Wow..
Its working,
Thanks Fabio.
Shaila
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.
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
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
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
No effect,
Result is same, sale column appears twice.
Sorry. I understood what you need now.
The bad news is, it's not possible to do with pivot table.
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>
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.