Each level is a column from a single table. The table looks like this: Region | Dept | Employee | Sales Amt Region 1 | Sales | John Doe | 55 Region 1 | HR | Bob Smith | 110 Region 1 | HR | Chris Jones | 85 Region 1 | Marketing | Arnold Port | 33 Region 2 | Sales | Sid Nancy | 331 Region 2 | HR | Tammy Hughes | 231 Region 2…

I am still trying to resolve this issue. If there are any other ideas, please provide. Thank you.

I made sure each level has a key including each previous level. Still having the same issue.

Sorry. That was just a typo. I cannot copy and paste. I had to type out the formula by hand. Changing ID to "ID" produced the same results: "General Error near <select>"

That option is not possible due to my circumstances.

Thanks Christian. It turns out that I had a <prompts> element at the bottom of my xml with the incorrect subject area.

Nothing too complicated. I only want the sum of sales for the year and the profit for the year. So, one line per year per vehicle type. i.e. type year sale_price profit car 2012 16000 500 car 2013 19000 600 boat 2012 42000 1200 boat 2013 58000 1400 bike 2012 8700 200 bike 2013 10300 300

Could you point me in the direction of some documentation or a tutorial? Thanks.

Thomas, thanks for the response but you might as well have been replying in Greek. I have no idea what any of that means. Can you point me to a website that may be able to enlighten me?

Does anyone have any additional information or possible tips/tricks to help me accomplish this? Thank you