on 03-28-2017 10:22 AM
Hi,
We have a hierarchy as below :
+ India 40
A 20
B 10
C 10
Total of India is 40.
Now when i apply report level filter to exclude A it shows as below :
India 40
B 10
C 10
As we see, the Node A disappears from the layout but still the Parent total is unaffected and it still shows 40. Users want India to show as 20 after excluding Child Node A.
I need the output as below :
India 20
B 10
C 10
Please let me know if this can be achieved in webi
Hi,
Did you manage to find a solution? I have the same problem now
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit,
Please refer my above comment for hierarchy.
Also i tried excluding the node as you have show ,but still the parent Node Commerical total remanins unaffected.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
c3.pngPlease refer to the below hierarchy.
When I apply the filter to exclude the Commericial Prog Node, the node disappers from the display but the total of Commerical is still 4.2
(Ideally after excluding commerival org node, the total of commerical node shuld be 4.2-0.7=3.5)
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.