sum of pivot table

[pirotfab]

Hello, Is it possible to display only the total in a tcd?

For example, we develop the other dimensions but the expressions is calculate only on the total line?

thank you in advance

[krishnacbe]

Can you share sample data and expected output?

[pirotfab]

[krishnacbe]

What is the Expression you used for TRS?

[krishnacbe · Accepted solution]

Hope the attached file will help you.  Replace the expression you have used for TRS in below expression.

f(Dimensionality()=1, sum(Quantity)/sum(TOTAL Quantity),'')

[pirotfab]

it's ok, thank you very much

[krishnacbe]

If the Solution worked for you, close the thread by marking the correct answer.