Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
In a straight table I have 6 dimensions:
- building
- 5 dimensions of hierarchy product: product 1, product 2 ...
There is no link beetween my expression and the hierarchy of product. So, I want to have the total of the building for every rows.
For example:
Building 1 | Product 1 | Product 2 | Expression
1 | 1 | 1 | 150
1 | 2 | 2 | 150
2 | 3 | 1 | 100
2 | 2 | 1 | 100
...
Can anyone help me?
Hi,
You can use the TOTAL keyword in your expression to achieve this.
your expression will look like sum(TOTAL <Building> Value)
here Building represents the name of the filed which contains the building dimension and Value represents the name of the field which contains the value for the building.
May be this help you.
Thanks & Best Regards,
Kuldeep Tak