Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thank You very much. You solution works fine.