Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Всем привет
Вопрос: возможно ли ограничить пределы измерения в сводной таблице, как это позволяет функционал в диаграммах?
При выборе сводной таблицы вкладка специальная вкладка пропадает,
но ранее видел демонстрацию сводной таблицы, в которой было ограничение по некоторому измерению. Задачка там была: отображались топ 5 контрагентов по продажам внутри каждого региона (измерения - регион и контрагент, выражение - сумма продаж)
There are two ways to achieve this
1)using a calculated dimension
2)restrict values in set analysis
Example: to show top 5 companies by sales
1)to restrict dimension values, add calculated dimension as below
If (Aggr (Rank (Sum (sales)),Company)<=5,Company) // and check suppress when value is null on this dimension
2)to restrict in set analysis
Sum ( {< Company = {"=Company = Rank (Sum(Sales))<=5"}
>}Sales)
There are two ways to achieve this
1)using a calculated dimension
2)restrict values in set analysis
Example: to show top 5 companies by sales
1)to restrict dimension values, add calculated dimension as below
If (Aggr (Rank (Sum (sales)),Company)<=5,Company) // and check suppress when value is null on this dimension
2)to restrict in set analysis
Sum ( {< Company = {"=Company = Rank (Sum(Sales))<=5"}
>}Sales)
Thanks
1) - its all ok
2) - doesn't work. maybe i made a mistake.
Can you fix it in file?
I'm on mobile right now
Also, with the second method there is a possibility that we may need a keyfield
Or may be try
Sum ( {< Company = {"=Rank (Sum(Sales))<=5"}
>}Sales)
It's ok!
Thanks bro
Just checked your app buddy
you need to use double quotes
Sum({<Organization={"= Rank(Sum(Sales),4,1)<=3"}>}Sales)
cheers
V