hi,

i have done this problem

thanks for your support.

yes

hi,

if i select 1 it display 1

or select 1,2 its display the 1,2

or select 1,2,3 its display the 1,2,3..

or select the 5th company its display the 5th company data ...

hi ,

if i select one company it display for one company income statement ,

if i select multi company(total 18 company ) it display the all company income statement

fixed

hi,

thanks for ur reply..

i clearly explain u...

we have company master table ,

company

=======

A

B

C

D

E

...etc

transaction table per company as

A$Item

A$ValueEntry

A$Customer

B$Item

B$ValueEntry

C$Item

C$ValueEntry

this is tables in sql,now i have design the cube,i need insert sales amount for...