

Hello everyone,
I have a Story in SAP Analytics Cloud that is going to be used to see customer account info. I have one chart that uses a Bill Date Dimension (has a date hierarchy drill that groups into year, quarter, month), the account ID and some calculations.
This bill date dimension is weekly bill dates, so some accounts will have multiple bill dates in each month.
The issue is that I am trying to see a count of the first ever bill date for these accounts and when I use the date hierarchy drilling the calculation that uses the first operation aggregation isn't working.
When I drill down to months, the calculation is giving each account a first bill date for each month, which I don't want. I just want to see the all time first bill date, but I want drill down to months for the analysis.
But, when I keep the date hierarchy drill to "(all)" it is giving the correct number of accounts.
Is there anyway to do this? I tried to explain this the best that I could, comment if anyone needs more info, thanks!