Subtotal calculation in reports

[Juanjoge]

I am generating a report in which I have 3 divisions of information

• Category
• Input/Output
• Payment type (Credit card/casj/Transfer)

and according to this it shows me the information in the report table. I am looking to calculate the subtotal of each of these divisions and the instruction I am using is as follows.

<<SUM( SELECT(Notes[Total service],[Type_of_Payment]=[_THISROW].[Type_of_Payment]))>>

The above seeks to make the sum on the data that is throwing me in the table that are the operations by type of payment but it throws me zero. What am I doing wrong? If later I want to make the cut of the inputs and outputs to get the sum of them, where do

Thanks as always for your support

[TeeSee1]

---

@Juanjoge wrote:

[_THISROW].[Type_of_Payment]

---

I believe it needs to be [_THISROW-1].[Type_of_Payment]

[Juanjoge]

Many thanks @TeeSee1 unfortunately it didn't work 😞 it does add up, but I don't know what, but I'm sure it doesn't add up to what I need. 😓

[TeeSee1]

You might want to add another constraint [tipo_servicio] = [_THISROW-2].[tipo_servicio] as you have in the detail select expression.