1 of 1 people found this helpful
Diego, thank you for the ping.
Mary, I beg your pardon for not understanding your question.
What are you trying to achieve?
Without actually looking at the data it could be a blind guess.
If the problem is with "mixing aggregates and non-aggregates",
then a calc like these could help:
IF [Report Date Set Boolean] THEN [Sales] END
IF [Parameter Reporting Date] = 1 THEN [Sales] END
where [Sales] should be an original datasource field
or Row-Level Calculated one.
Please find the attached workbook (version 9.0) with your calcs replicated.
But once again I'm not sure I could get your question right. Please explain.
Thanks but unfortunately I think I am limited due to not being able to use [Measure Names] within a calculation.