how to sum multiple rows below - pivot table

Wed, 09 Apr 2014 18:06:01 GMT

I need to make a table with the total billed value on YearPeriod x

this is a start, i need to translate this afterwards in payed days in adition to the costs (work in progress)

how can i create Wanted Value?

Re: how to sum multiple rows below - pivot table

Mon, 14 Apr 2014 09:58:41 GMT

rangesum

(
below(
sum( {$<
YearPeriod= {">=1900001"}
>} WIP)*-1,
0,
noofrows()-rowno())
)

found it out, solution was on : noofrows()- rowno()