Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
can any body tell me adv of relative property in expression tab
Hello Venu,
When you check this option, you'll see the % representation of the values over the total.
As an example if you have the following dimension/values:
A = 50
B = 20
C = 30
you'll get the following output
A = 50% (A represents 50% of the total values) = Value of A * 100 / Total values (which in this example is 100)
B = 20% ( B represents 20% of total values)
C = 30% (C represents 30% of total values)
I hope this helps.
JV
Compute the % from your expression and total amount of the expression
can u please elobrate with example
Hello Venu,
When you check this option, you'll see the % representation of the values over the total.
As an example if you have the following dimension/values:
A = 50
B = 20
C = 30
you'll get the following output
A = 50% (A represents 50% of the total values) = Value of A * 100 / Total values (which in this example is 100)
B = 20% ( B represents 20% of total values)
C = 30% (C represents 30% of total values)
I hope this helps.
JV
Month, Val
Jan, 10
Jan, 5
Feb, 15
Mar, 40
Apr, 25
Expression is Sum(Val), Dimension is Month
so you will see in your table:
Month, Val
Jan, 15
Feb, 15
Mar, 40
Apr, 25
If you add relative:
Month, Val
Jan, 15, 0.1578 (=95/15)
Feb, 15, 0.1578 (=95/15)
Mar, 40, 0.025 (=40/95)
Apr, 25, 0.2631 (=25/95)