How to avoid counting multiple times when summarizing
Hello everyone !
I came to ask a question here with a case i'm sttrugling with, i hope i will be clear enough with my explanation, don't hesistate to tell me if it is not clear.
To contextualize a bit : i'm working basically with two hierarchical lists that goes from :
- GP0 Zone, GP1 Region, GP2 Country, GP3 Store
- P1 Subvision, …….., P6 Reference-Color
I have a Line Item where i retrieve an information that says : the number of P6 Items that were ticked by GP1 Region. For example here, i have a P6 Item that has been ticked by one GP3 Store in the US , hence the value 1 for US RWH (at GP1 Region level), same goes for MEXICO RWH
Now i need to retrieve the info at the GP0 Zone Level (AMERICAS, in my example), that goes like this :
The issue i'm having here is that when i display datas at the GP0 level , my Line Item will count 2 meanwhile i should get 1 because both US RWH and MEXICO RWH ticked the same P6 Reference (as shown in the screenshot above).
I don't know if anyone here has been through that kind of case but i'll be thankful if anyone has a tips !
Thank you very much !