This content has been marked as final.
Show 2 replies
-
Re: Button
Vineeth Pujari Oct 6, 2017 2:57 PM (in response to Anil danda)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
-
Re: Button
pradosh thakur Oct 6, 2017 3:57 PM (in response to Anil danda)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