I have a set analysis which works fine until I have got one company group selected. If I select more company groups or clear the filter it doesn't show any figures. Just a bit explanation for the data set. Every group has got different start and end date it is like a membership expiration date. I would like to get the sales within their time of membership status. When selecting a month it nicely accumulate month by month and when it reaches the end date it will not show accumulation further only the sales up to the end date. As I said it works perfectly until I have got one company group selected. Any idea what is missing?
Since the start and end date differ, you won't really be able to use set analysis... you might need to use if statement with aggr function. In case you need help with a specific expression, would you be able to share a sample to help you better
you can try including the "company group" as one of the dimenions in the existing chart
If you have multiple Group Names with the varying dates then definitely you have to include the "company group" as a dimension in case you need to compare the data for themusing your current set expression.
You can cross check your data by creating a straight table by
It marked. It works perfectly. I have tried before with IF but I used outside of the AGGR function so it hasn't worked for me. Can I have some explanation what is the difference withing the AGGR or outside of the aggregate? Is it basically part of the set analysis in this case or still not?