Hi,
Thanks for the reply. I think you might have misunderstood my requirements.
The link you have provided for the ejGrid control provides filters for a column. This isn't what I need. What I need is the ability to have a each column in the report calculated (using filters) in different ways.
Using my example:
- Column A is a list of account names
- Column B is a sum of sales (for the account in column A) with a filter on the column to only count sales for Product X in the year 2016
- Column C is a sum of sales (for the account in column A) with a filter
on the column to only count sales for a group of products (Brand Z) in the year 2016
- Column D is a count of calls (for the account in column A) with a filter
on the column to only calls where call type = 'Phone Calls"
- Column E is a count of calls (for the account in column A) with a filter
on the column to only calls where call type = 'Faxes"
As you can see, columns B-E all related to column A but are basically subqueries in that I want each column to be calculated in a different way based on a set of independent filters on each column.
How can I achieve this?