Group Expressions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Thank you

Re: Group Expressions

Anil_Babu_Samineni — Wed, 26 Oct 2016 16:03:44 GMT

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.