How to create a classify chart

[#1]

Hi all,

I need to create a table like this. The main question is about the column 'Group' and 'Name' which are the dimension. How to do that?

Group	Name	Sale percentile	Sales
Group 1	Tom	10%	1
	Lily	30%	3
Group 2	Jon	20%	2
Group 3	Will	40%	4

Thanks.

Jelly

[#2 · Accepted solution]

I think you can use the pivot from the charts.

[arulsettu]

hi

post your data source

[its_anandrjs]

Hi,

Definitely you can use Pivot Chart here due to your requirement.

Regards

Anand

[#5]

Hi,

Yes the pivot table is useful. And how could I remove the plus sign from the table so that it will not show in report?

[rwunderlich]

On the Presentation Pane, check "Always full expanded". That will remove the +/- icons.

-Rob

[hariprasadqv]

Hi,

use pivot table. It will take care of the format.

[#8]

Thanks so much!