Show Percentage?

[Anonymous]

Hi,

I have a data of different vendors from different countries with their respective invoice amounts. Is it possible to show the percentage of a respective vendor to the total of its country?

If I select vendor ABC Ltd, I want to see it's share of 10% of total invoice amount in US.

Thanks for the help

[Anonymous]

Hi Sunny,

This works, is there a way to show only a few vendors to include in this? E.g. if I just want to see Vendor = Dell and Microsoft only.

Thanks

[sunny_talwar]

Both in the numerator and denominator or or just in the numerator?

May be this:

Sum({<Vendor = {'Dell', 'Microsoft'}>}[Invoice Amount])/Sum(TOTAL <Country> {<Vendor = {'Dell', 'Microsoft'}>} [Invoice Amount])

or

Sum({<Vendor = {'Dell', 'Microsoft'}>}[Invoice Amount])/Sum(TOTAL <Country> {<Vendor>} [Invoice Amount])

[Anonymous]

Thanks a lot