Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone ,
I have problems to calculate "% of participation per client"
The calculation what i use is:
SUM({<[Sales YTD]={1}>}[Net Sales])/SUM({<[Sales YTD]={1},[Client Name]=>}[Net Sales])
If i divide the metric in two:
Show net sale year to date based in selection
Show total net sale year to date ignoring selections ( In this case total net sales)
But when i put this two metrics in a table with Clients, both metrics show the same number and of course if i use the firsth complete metric the result is always 1.
My objective with that is obtain the "% of participation per client" acumulated.
Is this posible ?
Thanks in advanced.
Hi Alvaro Garcia,
Please have a look at the attached qvw file and let me know if it works for you.
Thanks
Mouna Chandra
There's nothing inside that .qvw except an inline table?
I am sorry, I am not sure why you are not seeing the table in front end.
I am using the below measure to calculate the % accumulation.
=rangesum(above(sum([Sales YTD]),0,RowNo()))/sum(total [Sales YTD]).
Please this use this as a measure in you expressions it will give you the percentage.
Thanks
Mouna
Hi
I think using ABOVE function to take the previous percentage and add the percentage of the current row.
Maybe this:
Better if you use RangeSum as mounachandra1 said
RangeSum(Above(Sum([Sales YTD]),0,RowNo()))/Sum(total [Sales YTD])
Here is the example:Accumulations
Can you please close the threat by marking the correct answer, so that might be helpful for others.
Thanks
Mouna Chandra