Hello All,
Aggregation function not working properly.
At present i am getting values as
| Type Of Plant | =DATE(Date) |
|
|---|
| A | 4/1/2012 | 135.00 |
| 5/1/2012 | 162.00 |
| 6/1/2012 | 189.00 |
| 7/1/2012 | 216.00 |
| B | 4/1/2012 | |
| 5/1/2012 | |
| 6/1/2012 | |
| 7/1/2012 | |
| C | 4/1/2012 | |
| 5/1/2012 | |
| 6/1/2012 | |
| 7/1/2012 |
|
i need is
| Type Of Plant | =DATE(Date) |
|
|---|
| A | 4/1/2012 | 135.00 |
| 5/1/2012 | 162.00 |
| 6/1/2012 | 189.00 |
| 7/1/2012 | 216.00 |
| B | 4/1/2012 | 135.00 |
| 5/1/2012 | 162.00 |
| 6/1/2012 | 189.00 |
| 7/1/2012 | 216.00 |
| C | 4/1/2012 | 135.00 |
| 5/1/2012 | 162.00 |
| 6/1/2012 | 189.00 |
| 7/1/2012 | 216.00 |
ie In the last field i should get the total for all the Type of plant wrt to a particular date
Please find the attached qvw.
Thanks and Regards,
Priya
