Dynamic Matrix Table

[krixtsup3r]

Hi All, need help on creating a dynamic matrix table.

That will allow the user to have flexibility, in selecting the columns based on a Slicer. See below for the expected output:

The section of measures is computed based on "Actual", "Plan" and "Forecast" which can be dynamically selected on the slicer.

it should also allow the user to dynamically select a period, like if they select Month, that would allow them to select 2 different month, same goes with Year, Half Year and Quarter.

Thank you so much, I am so stuck on how to create this. Any help is much appreciated.

[Mahesh0016 · Accepted solution]

@krixtsup3r Please refer this link https://youtu.be/2y2VP6i8S8c
i hope this helps you.