Set analysis Group by

[shanky1907]

Hello,

i am facing an issue in which there is sales data according to geographical hierarchy as country -> Districts -> Bricks.

So i am takign the sum of sales. But when i select the sales data to be shown as Bricks, it is showing me much larger vlaue for the same country if i comapre it with the country sum.

Please suggest some solution or reason to this issue.

Thanks

[sunny_talwar]

Can you share the expression you are using right now?

[shanky1907]

=(sum({</*Variable Comparison*/>} [Net SI value])+sum({</*Variable Comparison*/>}[Net SO value]))

These variables have nothing to do with the geography.

[sunny_talwar]

So Sum of Sales for District (for a particular country) is more than Sum of Sales for the country???

[shanky1907]

for district and coutnry is same. But for Bricks it is much more for the same country

[sasiparupudi1]

please post your application