one way is to not use the totals query as the base for your report and to use a Matrix instead of a tablix. You could create a variable to...

Did you check the "Allow Multiple values" in the Parameter properties? If not, it will default to single-select instead of Multi-select. (And then you under FILTERS, have to change [Field]=...

Right here...

) T1

WHERE <filters>

GROUP BY

It goes after the FROM clause and before the GROUP BY clause

Okay... Could you post what the solution looks like given the data you originally posted? (Or did you do that already?)

So you would apply the new payment to the oldest...

Awesome... now I know what the question is! <g>

You're doing FIFO (a queue), but with money. So the oldest debt gets paid first, and if there's any money...

I think I get it... you want to apply amounts to the oldest debt first, and then carry forward any remaining money and apply it to the next oldest debt....

Oh wait... I think I get it. You're kind of looking for patterns in when each debt gets paid off... so older debts (which are theoretically accruing interest) are...

I give. I don't get it. I see how in theory you should apply debits to credits or whatever, but I'm not sure why it matters. I must be missing...

Sorry, my installation of SSRS 2008 and even 2008R2 are both long since gone.

In 2016 (so this may not work for you), you go to Parameter Properties.

Check Allow Multiple Values.

Go...

Could you please explain the logic of how you get to the expected result? The running total over the CustomerID is really close, but wrong somehow... but why?

How is the...

Here's my setup so other folks can play along:

--TransactionIDCustomerTransactionTypeDateAmount

SELECT CustID

, TransID

, TType

, TDate

, Amt

, SUM(Amt) OVER (PARTITION BY CustID

ORDER BY TransID

ROWS BETWEEN UNBOUNDED PRECEDING

AND CURRENT ROW) AS...

just wondering... what if you used a windowing function and did a running total of the value (credits are positive, debits are negative). Then it would act like a checkbook

SUM(value)...

Okay, looks like I got bit by the "Reading Is Fundamental" bug...

The short answer is CALCULATETABLE.

When I actually OPENED Ferrari & Russo's DAX Patterns book, there's a chapter on Surveys...

This kind of begs the question... If I had a resume like

SQL Developer 2<24 months>

Company ABC

SSMS, SSRS, SSAS

SQL Developer 1<36 months>

Company XYZ

SMS, SSRS

how would you count my experience? doing...

Hmm.. that might explain the defective light saber...