I am trying to build a report showing based on the same table to compare the purchase price of items based on selected month and comparing these items to its previous entry.
For example:
Month and year selected - Feb 2013
A - $1
C - $3
D - $2
How can I compare side by side items A, C and D's last purchase price as they might be bought in different months?
For example:
A - last purchase in Jan 2013
C - last purchase in Dec 2012
D - last purchase in Jan 2011
In my report, i have put
if(previous("ItemNo")=("ItemNo"),previous("Document_No"),'Most Recent') as RecentFlag
but it only returns the unique item bought for the month if there is any replications in the items bought in the same month
Can anyone help me on this?
