Pivot Table

upaliwije — Sun, 08 Jun 2014 15:53:21 GMT

I have above pivot table where 1 st column indicate the product

2 column shows total returns for the month of may

3 column goods returned after 25th of any month

4 ,5,6,7 columns should show the returns value in relation to purchased months of goods returned (after 25th day)

My expression for 2 and 3 columns are as follows

2 column SUM(RETURNS)

3 COLUMN =SUM({<R_DAY = {">25"}>} [RETURNS])

R_DAY=Returned day

R_MONTH = Returned Month

P_Month= Purchased Month

above are dates in master calender.

Pls help me to write the expression for the above 4 columns (4,5,6,7)

topic Pivot Table in QlikView