Top 8 customers in a trellis container

[ali_hijazi]

Hello I got a combo chart with one dimension (Month_year)
and 3 expressions (stacked)
exp1: sum({<KPI={spent_mandays},portfolio={87},project_type={123}>}amount)
exp2: sum({<KPI={spent_mandays},portfolio={87},project_type={456}>}amount)
exp3: sum({<KPI={spent_mandays},portfolio={87},project_type={789}>}amount)

alone as a chart chart displays data normally

what I want is to repeat the above chart 8 times for the top 8 customers
so I added the above chart as a master visualization, and added a trellis container to which I added the customer dimension as follows:
aggr(only({<customer={"=rank(sum({<KPI={spent_mandays},portfolio={87}>}amount)) <=8"}>}customer),customer)

but the trellis displays the customer but the charts got the same values for all 8 customers

[lennart_mo]

Hi @ali_hijazi, 

Could you please check whether you have 'Advanced Mode' activated under 'Appearance' -> 'Trellis options'?

If so, try disabling it and see if the results change to what you'd expect. Should the results change but you need the 'Advanced mode', you'll need to add $(vDimSet) to the end of your set expressions, i.e.

exp1: sum({<KPI={spent_mandays},portfolio={87},project_type={123} $(vDimSet)>}amount)

Best regards

Lennart