Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Here is the issue, i already have a box with data that is selected with a calculated dimension:
=if(aggr(sum(Sales),Description)>Average_Sales
AND aggr(Sum(Margin),Description)/aggr(sum(Sales),Description) > %Margin
,Description)
With this sentence im able to select those products that are above the average sales and those who margin more. and till that point, all is good.
now, i want to know the sum of sales of all those products which im trying with
=sum(if(aggr(sum(Sales),Description)>Factor_Prom_VNF
AND aggr(Sum(Margin),Description)/aggr(sum(Sales),Description) > %Margin,Sales))
But this way I only get the first (or last) value of the list of products (Description = product name)
hope someone can help me.
thx in advance