Need Help !

[dhanu_today]

Hello All,

I have calculate the data as per the attached source.

The desired output shouls be as below.

Company_segment      Count(company_codes)     Count(accounts_no)    sum(balance)

Please find the attached source data and the application as well. let me know any concerns..

Thanks in advance,

Dhanu

[dhanu_today]

Thanks Loannis..But with this data model...i didn't get the table 1 output say the fields comp_bs_segment and comp_ps-segment.

[giakoum]

.....

BS_Segment as comp_bs_segment,

PS_segment as comp_ps-segment,

.......

[dhanu_today]

Could you please share the app what the way you did...I need to show individual level BS_segement, ps_segemnt, and comp_ps_segemnt , comp_bs_segment in company level.

Thanks

dhanu

[giakoum]

How do you calculate the last 2 columns? Comp_BS_segment and Comp_PS_segment?

Otherwise see attached