I have a report which columns given below.
Sno Project Name Project No Bill Raise Amount
1 abc 0213 YES 123.33
2 xyz 0232 NO 23.33
3 asd 0365 YES 125.65
4 rty 0325 254.52
5 hjkg 0254 NO 236.22
and i am using dataenvironment->command1
My requirement is Sum Amount (YES) ?
Sum Amount (NO) ?
Sum Amount ( ) ?
I can get only one at one datareport
Please tell how can i get all of above individual amount (YES and NO and blank) in one data report in a single data report