indeed the answer above is AI generated, it is not working. Yes, I need a report with all the stores, and for every store one column like this: Country1: City1, City 2 ;Country2: City1 , City 2 Report should look like this, cities and countries should be ordered!! Store1 | Country1: City1, City 2; Country2 : City1 , City 2…

Hi, Can you add inside the column with Product Category another grouping? This is what I am looking for. Thank you, Ana

Thank you, THese are working for me, but I am trying to do 2 groups. For example, suppose that in the example from your last link, we have also Countries for each employee and I need to get smth like this: For each department, I need a column like this : US: list of employees, DE: list of employees. Can you help me with…

I tried to use EVALUATE_AGGR but in my request is not enough form what I tried. Can you provide the code? I need 2 levels of grouping : one by store and one by country and with EVALUATE i managed to do just one group, not 2.