pivot table: how to format field values, if dimension like something?

[#1]

Hi there,

is there a possibility to change the number format if the dimension is changed by user?

Example:

if (Dimension1 = 'customers', num(column1, '# ##0,#') , num(column1, '###.#'))

I dont know where to implement and how.

Thanks and best regards

Sabrina

[alexandros17]

Could you share your qvw?

[#3]

Sorry, but the employer forbids sharing 😞