PRODUCT | RETURNS_MAY | Above 25th Day | RETURNS PURCHASED MONTH JAN | RETURNS PURCHASED MONTH FEB | RETURNS PURCHASED MONTH MAR | RETURNS PURCHASED MONTH APR |
A | 64,084,661 | 45,747,412 | 0 |
B | 60,651,995 | 47,143,933 | 0 |
C | 41,744,189 | 20,974,150 | 0 |
D | 35,762,223 | 24,707,734 | 0 |
E | 24,843,223 | 16,197,837 | 0 |
Total | 359,662,112 | 224,263,911 | 0 |
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)