Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears,
Now I want to create a Market Share chart.
The first chart is the Market share of one company on it's region
This chart will show the revenue of one specific company (selected in a list box) in comparison with the total revenue of it's region.
The secound chart is the Market Share of one company compared with all companies
This chart will show the revenue of one specific company (selected in a list box) in comparison with all of the others companies.
The problem is that when I choose the company the sistem should count the total of this Company and count the total of the region, and then devide.
Example:
Company 1 is in the region A
So, the formula should count the total of company 1 and devide by the total of region A
How can I do it?
sum(Revenue)/sum(TOTAL <Region> Revenue)
Check what I did based on your help, but it's only showing the value 1, even if I select or not the company:
=sum([Claim Total])/sum(TOTAL <[World Region]> [Claim Total])
How can I solve it?
Can you upload the qvw so that I can have a look?
Thanks,
Dinesh.
Try this:
=sum([Claim Total])/
sum( {< Company= , [World Region]={$(=only( [World Region])) }>} [Claim Total])
No, It didn't worked... it's only showing -
Thanks
Try this then:
=sum([Claim Total])/sum( {< Company = , [World Region]={$(=concat(distinct [World Region], ',')) }>} [Claim Total])
It may not work if your world region has spaces in the text (like "South America"), in that case, you would have to change the concat expression...
It's not working again.
If all selections are clear, the result is 2,72049... and if I choose one company, the result is -
But I know that this company has revenue.
Thanks again for all your support Erich
Do you prefer to send a sample application so we can build the expression with your real data?
You can use scramble or data reduction for this
Yes,
I've prepared an example for you
It's not my DB, but its very similar.
Thanks for your attention