I need to have a table, where I can visualize a couple of metrics for specific periods on one line. So imagine I have a fiscal year field, which currently contains 2021 and 2022 as these are the years I have data for.
I need to create a table where I will have a metric on one line, which consists of these metrics - sum(Actuals) for 2022, sum(Budget) for 2022 and sum(Actuals) for 2021. The metric should be on a row and the years need to be separate columns. Please see attached screenshot for more details of how it should look.
I guess it should happen with a calculated dimension, but I can't think of a way currently.
I kind of works, but this is just part of the requirement which I have, as I need to have a different metric for every row, which needs to also be calculated for different year and be only one line. So let's say I will need to have Metric 2 on line two, but for 2022 it needs to be sum(Actuals), for 2022 again sum (Budget) and for 2021 it will be something different again.