Group Expressions

[Anonymous]

Hello,

I am doing the following pivot table:       

	Cost per Unit	Cost Total	Income per Unit	Income Total	Profit per Unit	Total Profit
Client

But now i want to Group the expressions by Cost, Income and Profit.

¿How can it be done to get something like this?

Cost				Income		Profit
		Cost per Unit	Cost Total	Income per Unit	Income Total	Profit per Unit	Total Profit
	Client

Thank you

[Anil_Babu_Samineni]

You may create one value list with that

Dimension - ValueList('cost','income','profit')

Expression - sum(costperunit)

Sum(income)

Sum(profit)

Then give partial sum from presentation

Now, my question is does.cost, income, profit coming from one table or different table.