I have a database table that has fields Category, SubCategory, Value and ReportDate. The Value is not a sales figure, it's a point-in-time valuation (think stock value on a given day). This gets populated every day, so I have rows with contiguous dates and the value changing each day.
I'm looking to make a table report that has Category, Value Today, Value 30 Days Ago and Value 90 Days Ago (these value columns need to be summed by category). Delta columns would be an added bonus. All the data required for something like this is in the table I think but I'm not sure how to approach it.
If I don't display my measures and just show [Category] and [Value] and add a filter on the ReportDate, I can see all my dates and selecting just 1 date results in a value I expect. I can also then just filter on a previous date and see the correct value for that date, but I want these to be side by side in the report.
I am having transaction amount, Status and date in my data. wanted to show the value with indicator showing green (if value is greater than previous day) or red (if it is lesser than previos day). Please help me on the same.