previous day difference?

[#1]

Hi,

I have a pivot table, which have days as one dimension. for each day i have to get a sum(value). in the next column i have to get the difference between the previous day and today. how can i achieve this??

please help..!!

[Anonymous]

Hi,

Try using above function

sum(value) - above(sum(value))

Regards,

Greeshma

[#3]

Hi..

thanks for your Reply...

can i get the same in script??

[#4]

you can use

today()-previous(today()) to achieve the same in script.

--

Amay

[Anonymous · Accepted solution]

Hi,

In the script you will have to use previous function.

Regards,

Greeshma

[tresesco]

Yes, you can. You have to use Previous() or Peek().

[jonathandienst]

You can, but that is not what you asked in your original post.

LOAD ....

     Sum(Value) - Previous(Sum(Value)) As Difference,

     ...

FROM ...

Group By <all other fields>

Order By <the relevant sort sorder>

Post a sample qvw and sample source data (text file or Xls) for more specific and detailed help.