I need to builda rankcompaniesfromsales value. In thissame tableI need toshowthe city,union andsome numbers. In somecasesthe companyhas more than oneinformation,city orunion.Howdo I create acell in thattable wherewhen Ihave more than oneinformation hassomething likea list ofrelated valuesthe companyI select? I amtrying for a longtimeand still can not. I'm trying to do this with pivot tables but i'm getting frustrating results.
You can't click on a list to 'open' it. If you click on a value in an expression column then you select the dimension values of that row. It is possible to show/hide a table based on those selections. But there is no way to distinguish between clicking on a value in the CNPJ or City expression columns. See attached example.