Hello there,
I am working on this Mekko chart, we are talking here about the split of different companies. in my case, i need to regroup 3 of them (Fnac rive, fnac balexert and Billeterie fnac).
what would be the best thing to do ?
Right now, the dimension is Name_company.
thanks for your help
JP
Hi,
You can group the Company Name in the Backend using Inline Table.
or you can try the calculated dimension like,
=if(WildMatch(Name_company,'*fnac*'),'FNAC(Group Name)',Name_company)
find attached for reference.
Can you expand a bit more of what you end requirement is, maybe knock up an example application or provide a view of how the end result should look.
Joe
Hi,
You can group the Company Name in the Backend using Inline Table.
or you can try the calculated dimension like,
=if(WildMatch(Name_company,'*fnac*'),'FNAC(Group Name)',Name_company)
find attached for reference.
i have done the calculated dimension and it works perfectfly