Hello I got a master visualization which is a combo chart with 3-bars expressions (stacked) and a line expressions the combo chart looks something like this:
Now what I want is to break this chart by the top 8 accounts but the trellis is repeating the chart for all 8 accounts
I put advanced mode and added to the expressions the $(vDimSet) and in the dimension I put the following dimension: =Aggr( If( Rank(Sum({<[Portfolio Level 2 ID]={87}, SCENARIO_TYPE, SCNR_TYPE_ID={0}>} AMOUNT * MANDAYS_SPENT * FLG_MANDAYS_SPENT_INCL_DU), 4) <= 8, ACCOUNT_DESCRIPTION ), ACCOUNT_DESCRIPTION )
but all in vain I also put the ACCOUNT_DESCRIPTION as the dimension in the trellis and moved the logic of the ranking to the expressions but trellis displays blanks or diplays 1 bar expression and repeating it as above i tried to put 8 distinct charts but the performance is extremely slow kindly advise