Hi

[#1]

    i have one pivot table with one month dimension and two measrures (sales1 and sales2like this

       jan  feb  mar  april  may  jun  july  aug  sep  oct  nov  dec

sales1    10   20     20    10    30  40     10   20     20   30   10   20

sales2   30    20     20     50   60   70     80    10    80   20   20  90

so here i need a column at right side which adds last 3 months values for both sales1 and sales2 like this

            jan  feb  mar  april  may  jun  july  aug  sep  oct  nov  dec     latest_3_months

sales1    10   20     20    10    30  40     10   20     20   30   10   20         60

sales2   30    20     20     50   60   70     80    10    80   20   20  90       130

could u please tel me...

[tresesco]

Where do you want this? In the script or UI?

[#3]

thanku for your response... UL only (QLIKVIEW)

[#4]

UI only (qlikview)

[tresesco]

What is the dimension name for sales1, sales2 ? Could you post a sample qvw?

[trdandamudi]

With out sample app it is very difficult to give a suggestion. Any have I just created a sample app for you and attached here. So please take a look and hope this helps...