Grouping of expression in straight or pivot chart

[#1]

Hi,

I need to show the data like this in the chart. The right side theree fields are three different expressions , I want group them under sales. So how can I do this? Please help me on this.

Sales	Sum of sales
	Count of Employees
	Division wise sales

[Gysbert_Wassenaar]

Use a pivot table object and drag an expression column to the left until you see a fat vertical blue arrow. Then let go of the mouse and the expression should be placed as rows in the pivot table.

[#3]

HI Sowmay,

By using Pivot Table you can do grouping.