I have a challenge that I can not figure out. This is the situation.
I have a Fact table with all purchasing transactions (quantity and amounts).
Items/vendor/Year are dimensions. And the Average Purchase Price/year is the expression.
I want to visualize how items purchase prices between the selected year periods are changing to see the differences and large discrepancies.
What object to use and how.
Thank you for all your help.