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
