Forum Discussion
Pierrechapar
4 years agoFrequent Visitor
Help with % in stacked column chart.
Hi all, I've been looking aroud to see if I could find anything to help me solve my query. Since I didn't I turn ove tou you guys for help. I have this stacked column chart that displays num...
Pierrechapar
4 years agoFrequent Visitor
I've found a very simple way around this issue.
I created a 2 columns in the table to reference the series and a Disctinctcount of customers, based on the parameters that are on the slicers. As I get the same number in mutiple row I just used a MIN tu get 1 number in particular.
The Problem now is that althoughis working fine for individual countries in a slicer, as soon as I choose 2 or more it does de distinctcount correctly, but it doesn't sum up the reference period.
I modified the formula not to use the min, but to sum up the references for those countries using a Rank so I don't repeate any unwated data. This doesn't work. It still only takes the numbers of 1 country instead of the sum of all the selected.