I am a newly beginner SSRS developer and want to create a comparison report.
My dataset contains the following columns:
ClassID --> Product class ID
Year --> Product Year
WeekOfYear --> indicates week of the retail transaction date
SatisMiktari --> SalesQuantity
My purpose is to create a report that contains the following 3 columns:
WeekComparison (A calculated columns that compares previous week and the last week of the sum of SalesQuantity)
How can I do this?
Any help is appreciated..