We are trying to drill down on our dashboard using multiple filters.
Our requirement is: Business division --> product category --> sales brand --> SKU code
I am not able to make the connections with the "sales brand" filter in our back-end for any column because the sales brand option isn't appearing in the drop-down menu for any element (please refer to image-2). I have added the sales brand columns to the table for each element (please refer to image-3) using the necessary custom query (please refer to image-4) but the software is not showing us an option in the dashboards back-end to connect the sales brand filter.
Will be glad if someone can help resolve this issue!