Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)