Overall Total for an Entity to be shown overriding the screen selection

Efraim

Hi,

Is it possible to get the Overall Total of an Entity so I can get the % of Total even when there's an active Screen Selection?

The sample table below show all Entity. Let's say Entity A is selected in the Screen. I still want the All Entity Total to show 75 even when the table is filtered. I will use this value in a Label not in a Dataview.

Helmut Heimann

Hi @Efraim ,

You will need the "Refer-To"-Function for that.

The block you would like to calculate the total on needs to have a reference to the entity you want to compare. This is called a block-selection.
Please have a look at our manual here https://help.board.com/v14/docs/about-data-block-settings#refer-to

B