Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.