Hierarchy in set analisys

[hanschucrutes]

Hello everyone, how are you doing? I'm working on a bar chart that has two stacked pieces of information: one is the year, and the other is the type of received values, Credit/Debit, along with the corresponding values. I need to create a drill-down feature where, upon clicking one of the year bars, the months would be displayed. However, I'm having trouble creating a set analysis with drill-down functionality. I did manage to create a hierarchical dimension of year > month, but I can't seem to use it within the set. Here's the formula currently in use: "=pick($(vYearReference), IF([Year Adjustment] >= 2022, [Year Adjustment]), IF([Year Written] >= 2022, [Year Written]), IF([Year Invoiced] >= 2022, [Year Invoiced]))". Can anyone help me with this?

[pallavsi_08]

Hi,

You should try creating the single Year field in backend using [Year Adjustment],[Year Written],[Year Invoiced] field