calculation of percentage exculding few values

[savithri_n_s]

Hi

Can you please help me in getting percentage as shown in excel sheet  highlighted in pink using set analysis

If country = india and GL category group not equal to HR then the percentage should be

sum of addressable spend where country = india and GL category group not equal to HR divide by

Sum of addressable spend for all country  and GL category group not equal to HR

Regards,

Savithri

[sunny_talwar]

You need this in a text box object?

[Digvijay_Singh]

Try this -

=Num(Sum({<Country={'India'},[Gl Cat Group]-={'HR'}>}[Addressable Spend US$])/

Sum({<[Gl Cat Group]-={'HR'}>}[Addressable Spend US$]),'#,##0.00%')

[savithri_n_s]

Hi sunny,

I want this in bar graph

Regards,

Savithri

[savithri_n_s]

Thank you Digvijay

[ahammadshafi]

Hi Savithri:

Please try the attached one. Can you please let us know what would you like to show in the bar chart as dimension(s)? Cause after applying the requirement it seems like data for India will be shown only.

BR,

Shafi

[savithri_n_s]

Hi Shafi,

Thanks this help .I will try to modify from here based on my requirements

[Digvijay_Singh]

Not sure but may be by mistake you are marking your own posts 'Helpful' instead of help providers.