How to add an expression into a pivot table without being divided on columns?

[#1]

Hi,

I have a pivot table with details for two dimensions: Material in row and Month in column. I'd like to add a new expression in the table independently of the existing one, but not to be split into month detail (see the attachment - Col2). How can I do that without be constrained to add the expression split into months?

Thank you in advance,

Cristina

[Gysbert_Wassenaar · Accepted solution]

You'll have to add the expression as a calculated dimension. Perhaps something like =aggr(sum(ind1/(ind2-ind3)),Material)