Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
assume i have articles placed in several locations, like the following
What i want is to calculate the distribution quota for each article.
That means i have to get the total number of locations (here 2, namely a and b):
My problem is, that all suggestions for set analysis disregarding the selection are not working, like Count(distinct {1} location) or Aggr(...) or ..total...
I assume that the reason is, having article_no as dimension and having no connection between e.g. article_no 01 and location b in data model.
So how do i achieve to get the total count of locations?
Thanks for your help
Hi @DSDD ,
Could you post a sample app with mock data and explaining what are you trying to achieve?