Thank you for the reply. Unfortunately, I cannot attach the sample workbook but I did grouping also with the way you have suggested but it does not work. The hint may be the fact that I did grouping very well until I transformed some dimension filters into the context one. After I transformed them into context filter some items were not included in the group. I do not know how can I solve this problem. If I do not use the context filter I will get the incorrect results.
Thank you ,
Context filter creates a temporary table,therefore limiting the number of records available to all other quick filters.
SO when you are using context, the possibility is, it is filtering out the "group members".
My question is why are you using context filter?? As it's used mainly to improve performance.
Thank you for your response Meenu. I am using it because I am also using the Fixed Level of Detail Expressions and when I used the dimension filter instead of context filter, I got the incorrect results as Fixed Level of Detail Expressions are taken into account by tableau first and than dimension filters. When I used only dimension filter it grouped the data easily, but when I transformed the dimension filter into context one it did not group the data and some of them were left outside the group. So, I do not know how unify some columns into one with using the context filter.
Hi Nino, you may be able to remove the filters from context if you can add those dimensions to your LOD. It's challenging to suggest a specific solution without seeing sample dummy data.