Calculation - percentage per line

Dan Lykholt

April 21, 2024 12:54

Hello everyone,

Trying to get Targit to show percentage per line of the Total. Example below:

The "Total" 1705 Tryktræ should be = 100%. Then "Grundsortiment" should be (1.679.846 / 2.079.544) = 80,77%

The percentage for "Hjemtagelsesvarer" should be (174.036 / 2.079.544) = 8,37%

How do I set this up? Can anybody help. Thank you in advance 😊

1 comment

Ole Dyring
April 22, 2024 12:43
Hi Dan,

Insert a custom calculation "As a new measure".

Try this syntax:
```
sum(0, 0, m1) / sum(all, 0, m1)
```
The calculation should be number formatted as 'Percent'.

BR / Ole
0

Please sign in to leave a comment.

New post