Forum Discussion
Calculation sumX multiplication
Hi Anonymous
Here is a sample file with the solution https://www.dropbox.com/t/obELBigMGJIPqhHdActually I have tried the same solutions and they seem to work. The thing is it won't allow me to create the hierarchy slicer with pop-up a message saying that the relationship should be One - Many. I don't know how did you create it but arbitrarily shaped slicers usually causes trouble. Using them would require the use of KEEPFILTERS. Unfortunately I failed to simulated your case but you can refer to (2) When to use KEEPFILTERS over iterators - YouTube
Following two workable solutions but using normal slicers.
Hi Anonymous
Here is a sample file with the solution https://www.dropbox.com/t/obELBigMGJIPqhHd
Actually I have tried the same solutions and they seem to work. The thing is it won't allow me to create the hierarchy slicer with pop-up a message saying that the relationship should be One - Many. I don't know how did you create it but arbitrarily shaped slicers usually causes trouble. Using them would require the use of KEEPFILTERS. Unfortunately I failed to simulated your case but you can refer to (2) When to use KEEPFILTERS over iterators - YouTube
Following two workable solutions but using normal slicers.
Hello, Thank you tamer for your help i really appreciate it!
it worked with the KEEPFILTERS function!!