Hi friends, How can I count countries with <4% Margin / count of total countries?

[jblomqvist]

Hi friends,

I have the following chart which shows Margin by customer:

The expression for my Margin is:

Sum(Margin)/Sum(LineSalesAmount)

How can I create another chart based on the above where I want to get the count of countries with margin < 4% / count ALL countries?

I can't figure out how to create this type of expression.

[sunny_talwar]

May be like this

Count({<Country = {"=Sum(Margin)/Sum(LineSalesAmount) < 0.04"}>}Country)

[Anonymous]

Sum(LinesalesAmount) /

Max(Total Aggr(Sum([LinesalesAmount]), Country))