i have made a Adhoc report in which i have given Dimension and Measure metrices
Dimension like
year
month
quarter
Customer
Division
Country
city etc
Measure
Sales
Collection etc
Now i want to add one more filter for metrices Say SUM, AVG, COUNT etc
Example:
Year Sales
2011 1000
2012 2000
2013 3000
2014 4000
Now If any user select say SUM then it should give me following adhoc report:
Example:
Year Sales
2011 1000
2012 2000
2013 3000
2014 4000
Total SUM 10000
Similar for AVG, Count etc
Pls suggest.
