Problem in percentage share on selection

[#1]

Hi community,

I have a chart with shows customer wise balances. Customer is taken as dimension where as I have written set analysis in expression to show balances. I created another expression with same set analysis and checked on 'relative' box, this shows me the percentage share of each customer, like this I have three columns

1.Customer

2. Balance

3. Percent Share

Without selection it works fine, but when ever I select a customer, the percentage shows 100%, however what I am trying to achieve is upon selection of any customer the percentage should show the percent share of that customer in total portfolio.

My expression is

=(num(NUM(sum({<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},Type ={'Financing - Funded'},ASSETS_CATEGORY -= {'3833'},FLAG = {'CORP'}>}BALANCE_CPS_FULL)/1000000,'#,##0')

+

NUM(fabs((sum({<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},Type ={'Financing - Funded'},ASSETS_CATEGORY = {'3833'},FLAG = {'CORP'}>}BALANCE_CPS_FULL)))/1000000,'#,##0'),'#,##0'))

Any proposed solution?

Thank you very much,

Usama

[settu_periasamy · Accepted solution]

Hi,

Relative % will work based on your display value..

may be  try somethng like

=Num(((sum({<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},

  Type ={'Financing - Funded'},ASSETS_CATEGORY -= {'3833'},

  FLAG = {'CORP'}>}BALANCE_CPS_FULL)/1000000)+

(sum({<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},

  Type ={'Financing - Funded'},ASSETS_CATEGORY = {'3833'},

  FLAG = {'CORP'}>}BALANCE_CPS_FULL)/1000000))

/

((sum({1<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},

  Type ={'Financing - Funded'},ASSETS_CATEGORY -= {'3833'},

  FLAG = {'CORP'}>}TOTAL BALANCE_CPS_FULL)/1000000)+

(sum({1<UPDATE_DATE_CPS_FULL={'$(=MAX(UPDATE_DATE_CPS_FULL))'},

  Type ={'Financing - Funded'},ASSETS_CATEGORY = {'3833'},

  FLAG = {'CORP'}>}TOTAL BALANCE_CPS_FULL)/1000000)),'#,##0.00%')

sample attached

[#3]

Thank You very much. You solution works fine.