Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following aggregate expression that sums the budget by ProjID & Month:
=sum(aggr(sum(DISTINCT[Budget]), [ProjID],Month))
This works beautifully in my chart, however, I would like to prevent the Month filter from changing the chart.
My chart has Sum of Budget in Y axis and Month in X axis. I tried doing this but it didn't work:
=sum(aggr(sum(DISTINCT {<Month=>}[Budget]), [ProjID],Month))
Try adding Month to the outer sum's set expression as well
=Sum({<Month=>} Aggr(Sum(DISTINCT {<Month=>} [Budget]), [ProjID], Month))
Try adding Month to the outer sum's set expression as well
=Sum({<Month=>} Aggr(Sum(DISTINCT {<Month=>} [Budget]), [ProjID], Month))
That worked great, thanks so much Sunny!
Note: There is an error on this website when I try to accept the solution. I keep getting: The page you are trying to access was not found. Please check your URL for typos and try again.
Happy to help 🙂