Hey !
For the first day of the week, its me again.
Lets say we have a cube with an entity called "position" it has like 30 members showing
various numbers. Now I put them into a Dataview and everything is fine. One of those entity
members is the total output. What I need is, a column with the percentage amount of the total output, for every single
entity in this dataview. As far as I know, calculation between entities are made with rules. I did it as the picture shows
but it gives me 0 for every member.
I would love to solve this problem with you guys because I think it normally should be an easy thing
Thanks for your help again and have a nice monday !
Regrets
Antoni Theodorou
Hi Antoni Theodorou,
Your understanding is correct, but I wonder if the total line is actually zero. Since these are all members in the same entity, the total line is usually defined as a sum of other elements. If the total line is zero, then your rules won't work as designed. If this is the case, there are a few options.
I'm sure there are other ways to approach it, but these are just two that come to mind.
Good luck,