How can I format a pivot table to show numbers divided by thousands

[#1]

I am trying to put in a button that will change the output of a pivot table so that instead of having a number read 34,400 it would read 34.4, basically having been divided by 1000. this is for a profit and loss pivot table and I want the users to be able to switch from a regularly calculated view, 34,400 to viewing it in thousands 34.4 using 2 buttons to switch back and forth.

Mike

[sunny_talwar · Accepted solution]

May be like a condition like this

YourExpression/vVar

where vVar is a variable which toggles between 1 and 1000

If(vVar = 1, 1000, 1)

[rubenmarin]

Hi Mike, you can use a variable, the buttons sets the value to '1' or '1000', then divide the expression by this variable value:

Sum(Sales)/vDivisor