Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have one query. I need to show the Top contributor in a text box.
Condition is: The number of sale of the vendor should be more then or equal to 2. So Top contributor should only be calculated amongst only those Vendors which has at least 2 Sales done.
The condition is very easy:
If(Aggr(Count Distinct SaleID), Vendor) >=2, Vendor).
The above condition is working fine in the chart as i have Vendor as a dimension and kept the calculated dimension as the above condition.
But when i use the same condition in the text box. It doesnt work well and consider all Vendors inclusing those which have single saleID also to calculate the average sale. [If(Aggr(Count (Distinct SaleID), Vendor) >=2,
num(Max(Aggr((Sum(Sales)/count(
distinct SaleID)), Vendor)),'##.#'))]
Can anyone suggest what wrong i am doing here or a better way to achieve the requirement.
Thanks a lot in advance.
May be this
FirstSortedValue({<Vendor = {"=Count(DISTINCT SaleID) >= 2"}>}Vendor, -Aggr(Sum(Sales), Vendor))
Here we are looking for the vendor name with the maximum sales with at least two sales. Is this what you wanted?
May be this
FirstSortedValue({<Vendor = {"=Count(DISTINCT SaleID) >= 2"}>}Vendor, -Aggr(Sum(Sales), Vendor))
Here we are looking for the vendor name with the maximum sales with at least two sales. Is this what you wanted?
Hello Sunny,
Is it possible to use one of the variable at the place of Vendor in the set analysis.
I don't know the context, but give it a shot....