Forum Discussion

RulkMartz's avatar
RulkMartz
Regular Visitor
7 years ago
Solved

Creating a Moving Annual Total Chart

Hi,

I've been trying to create a chart that shows MAT (Moving Annual Total) for a value in a table.

I've got a Star Model in which the fact table es Purchases and the dimension table is a Calendar.

I need to show the purchases of the month in a card but also the chart that shows the 12 months and its values to show the historic values.

I need the month and year filters to select the period and the MAT chart that shows the last 12 months including the current one.

 

I've already seen all the solutions that people propose in this Forum but none seems to fit my needs.

Thanks in Advance!