Pivot Table Column wise Running Total

[muniyandi]

Hi,

In My Requirement are pivot table ,columnwise running total need.

i tried before function is not get correct result

if(Week=1,Column(1),Column(1)+Before(Column(3)))

kindly refer attached excel file

Thanks,

Muni

[muniyandi]

Hi , anybody know the answer ,kindly help to me.

[#3]

Hi,

do you really need pivot table?

How many dimensions do you have in this chart?

regards

Darek

[muniyandi]

Hi Darek,

I need pivot table only.based on client requirement.

now i used only one dimension (week) for this chart.

[#5]

Mathew,

You may define island table with 2 fields: expressionLabel, number.

Define 1 row for each normal expression from your pivot + one additiinal

for this total accumulation A.

Then in pivot:

- use expression label as additional dimension

- use pick(number, expr1, expr2...) as expression.

I will try to find example later, If you need.

Anyway, this is much easier in straight table...

Regards

Darek

14-05-2014 06:11 użytkownik "Mathew Munish" <qcwebmaster@qlik.com>

napisał:

Qlik Community <http://community.qlik.com/> Pivot Table Column

wise Running Total

reply from Mathew Munish<http://community.qlik.com/people/muniyandi?et=watches.email.thread>in *App

Development* - View the full discussion<http://community.qlik.com/message/527822?et=watches.email.thread#527822>