sum in pivot table with RowNo ()

[francofiorillo]

Hello.
I need your kind help.
I have a pivot table, with three dimensions and different expressions.
With two variables, vDataMin and vDataMax, I limit the display of the lines only to those that have a value of <Data> included between these values.
On each line I calculate the number of days between the current line and the next line (column <Tot_Giorni>)
With the following expression

    sum (If (Data> = (vDataMin) and Data <= (vDataMax),
                        if (NextDate <= (vDataMax),
                                        Day,
                                        (VDataMax-Data)
                           )
                    )
            )

to this value I should add, for each article, the value present only in the first row (Val_Row_1 = 7, for example for article 40101653).
this value is calculated with the following expression
if (RowNo () = 1, sum (Data-vDataMin), 0)

having to use the pivot, in making the sum, while obtaining a correct value on the line (12 instead of 5) I cannot get a total of days for the correct article. In fact, for example, for the first article I always get 195 and not 202 (correct value)
can you suggest me how to write the sum of the columns for the pivot?
thank you in advance.
regards

[lfetensini]

Hi my friend.
Try: RowNo(TOTAL)

Otherwise, upload your app to better help.