KPI in percentage issue

[shani]

Hi,

I have 5 different type of goups which is 100% of the data but i want the percentage of the two groups out of five groups as KPI. 

for example

column1

customer 1

customer 2

customer 3

column2

rmapool

customer

scrap

What i want to show the kpi, if i choose for ex. customer1 it will count the reuslts 'rmapool' + 'customer' and show as percentage in KPI. But when i choose 'customer1' or any other options it show 100% as KPI result. 

[Anil_Babu_Samineni]

How is your data looks like?

[shani]

I have only one table with 122 columns.

do you want to see the list of all columns?