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