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

Efraim · 2025-07-09T15:32:08+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

Accepted answers

Helmut Heimann

Hi @Efraim ,

Yes, you're right—that would work with a parent entity that allows you to select "all".

The next possibility would be to define a cube without the entity you're using by row and flow the values into that cube, thus "getting rid" of that dimension. That cube will then always have the total value and can be used for comparison in the layout.

Best,
Helmut

All comments

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

Efraim

Hello @Helmut Heimann,

Thanks for the response!

I'm not sure if Refer To is applicable for my case. You can only select one member on the refer to right?

I need the total of all the members of the Entity (A+B+C). This Entity does not have a parent Entity that I can use in a refer to as well.

Helmut Heimann

Hi @Efraim ,

Yes, you're right—that would work with a parent entity that allows you to select "all".

Best,
Helmut

Efraim

I see so there's no other way of getting the Total using any functions within the Layout.
Will give the cube without the Entity a go. Thanks a lot!