How to get percentage for the belo graph

[savithri_n_s]

Hi,

Attached the qvw file. There are 2 bar charts in the qvw

In one of the bar chart i need the percentage of  # suppliers <= 10 contractors and  # suppliers > 10 contractors

Can you please help?

The percentage should be as below

CMT # suppliers <= 10 contractors should be  79% and # suppliers > 10 contractors should be 21%

FS # suppliers <= 10 contractors should be  74 %and # suppliers > 10 contractors should be 26%

H&PS # suppliers <= 10 contractors should be  77 %and # suppliers > 10 contractors should be 23%

PRD # suppliers <= 10 contractors should be  84 %and # suppliers > 10 contractors should be 16%

RES # suppliers <= 10 contractors should be  81%and # suppliers > 10 contractors should be 19%

Regards,

Savithri

[sunny_talwar · Accepted solution]

How are you getting 79% and 21% for CMT? 97/126 = 76.98%... if this is a typo... try this

Count(distinct([Supplier ID for Counting Unique]))/Aggr(NODISTINCT Count(distinct([Supplier ID for Counting Unique])), OG)

[savithri_n_s]

Thanks a lot sunny .your are really a star:)