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
Your seond expression is different than the first one. Can you please explain what are you trying to accomplish with the second statement? I could not understand your point.
Thanks
Hi
I put the first one in a calculated dimension of a simple table, so i know wich products join into the first group, then i add a simple sum(sales) into the expressions so then i know the sales of those products.
now i been asked to know the sales participation of those productos, i need the to know the sum value of them.
thx
Any thoughts? please
If u're using as dimension then,
aggr(sum(if(aggr(sum(Sales),Description)>Factor_Prom_VNF
AND aggr(Sum(Margin),Description)/aggr(sum(Sales),Description) > %Margin,Sales)), Product)
In looking to put the result as a Text box.
Could you upload a sample qvw?
Im adding an example.
Thx.
can't open ur qvw at the moment.
try and put sum around the expression above:
sum(aggr(sum(if(aggr(sum(Sales),Description)>Factor_Prom_VNF
AND aggr(Sum(Margin),Description)/aggr(sum(Sales),Description) > %Margin,Sales)), Product))
Hi,
It keeps showing me the top of the group, not the sum of all the elements.
Thx