Please see if the attached could be a first step for you.
I moved the [Order id] to the Detail shelf, which gave multiple
copies of the Sum.
I created a window calculation to sum all the revenue showing
after the filter:
IF FIRST()=0 THEN WINDOW_SUM(SUM([1_Sales].[Revenue])) END
I edited the Table Calculation Addressing to be [Campaign id], [Order id],
and then set it restart every [Campaign id]
Putting [Order id] on the Detail shelf causes multiple copies,
but the FIRST()=0 part just shows the first one.
210469My trying.twbx 38.2 KB
Swaroop, thank you!
It works perfect. Looks like it is what I was looking for.