Dear All,
I have four columns in my list report like
Date Sector SecName Closing Price
Jan 20, 2014 BANKS ABK 430
Jan 21, 2014 440
Jan 22, 2014 430
Jan 23, 2014 430
Jan 26, 2014 425
Overall - Total 2,155
now my requirement is i need to get total close price for each secname or sectorname for passing period like jan 20 2014 to jan 26,2014
Sector SecName Closing Price total closeprice
BANKS ABK 430 2,155
440 2,155
430 2,155
430 2,155
425 2,155
could any one help ke out this. your help is highly appreciable.
Best regards
Quote from: podaralla on 15 Oct 2014 02:50:38 AM
Dear All,
I have four columns in my list report like
Date Sector SecName Closing Price
Jan 20, 2014 BANKS ABK 430
Jan 21, 2014 440
Jan 22, 2014 430
Jan 23, 2014 430
Jan 26, 2014 425
Overall - Total 2,155
now my requirement is i need to get total close price for each secname or sectorname for passing period like jan 20 2014 to jan 26,2014
Sector SecName Closing Price total closeprice
BANKS ABK 430 2,155
440 2,155
430 2,155
430 2,155
425 2,155
could any one help ke out this. your help is highly appreciable.
Best regards
How about adding a query calculation as your new column, with the expression
total([Closing price] for [SecName])
Cheers!
MF.