I want to calculate Salience = This Year/ Total ( 500,000 / 980,000 )
and based on filters Total value will be dynamic
is it possible to access 980,000 to access in beast mode? Please tell me how to write a beast mode for this.
Unfortunately, you can't do totals like this in beast mode. You will need to do this in SQL or Magic ETL. It would be a nice enhancement if beast mode could eventually grab these totals as it is a common question.