I am stuck with this scenario, could you plz help me how to write script in backend to find Quantiy, show in below table. Here i want to show such data in Bar chart, weekNumber As Dimension and SIN,SOUT,Quantity as Measure.I want to write expression for Quantiy in the backend only.
For understanding purpose only i show like cross table, actually my data is like normal table with col weekNO, SIN,SOUT, Return. I want expression for Quantity in backend only. I used Previous() function but i am not able to write complete logic.