Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone !
How to link one graph to another where one of them has dimension limits?
The question is simple, both should express the same values, I explain:
Imagine the following scenario, two graphs with the same expression (SUM (SALES))
but with distinct dimensions, typical cube example.
The first is of the simple table type where the dimension is CUSTOMER field
and has dimension limits established by the variable VAR_TOP (N larger values)
The second is of the type bars where the dimension is CATEGORY field
* So you see, they both have the same expression. *
What I need is that the second chart (CATEGORY) respects or represents the values presented in a limited way in the first graph,
considering that both summarize sales, but with distinct dimensions.
For example (attached) if the total of the first graph (table) summarizes $ 900
then the second should also be tied to the same $ 900.
I've tried features like Rank, Aggr, I figured it's an indirect set analysis type, but for now without success.
In the attached files it is even easier to understand the demand.
Thank you very much for help
Achei a solução:
Na expressão memória de cálculo dos gráficos, para torná-la "sensível" ao ranking TopN da tabela basta mudá-la para:
Sum({<Cliente={"=Rank(Sum(valor),4)<=vTop"}>} valor )
Deste modo o campo [valor] será somado para clientes cujo ranking de valores forem inferiores ou iguais ao TopN (variável [vTop])
Achei a solução:
Na expressão memória de cálculo dos gráficos, para torná-la "sensível" ao ranking TopN da tabela basta mudá-la para:
Sum({<Cliente={"=Rank(Sum(valor),4)<=vTop"}>} valor )
Deste modo o campo [valor] será somado para clientes cujo ranking de valores forem inferiores ou iguais ao TopN (variável [vTop])