Button

Give a list to toggle example

load * inline [

ShowIn,DivVal

$M,1000000    <<Millions

$K,1000          <<thousands

$,1                       <<As Is

];      

change expressions to refer to selected DivVal

examples Sum(Sales) / DivVal

Create a variable v1 and set its value as zero.

Use the button to toggle the value of v1 between 0 and 1.

Create two columns one with M and another with complete count

Put conditional show hide for both as v1=0 for millions and v1=1 for complete count.

Now export to Excel.

Regards

Pradosh