Rangesum pivot table Rows

[ugurarslan]

Hi, 

I have created a pivot table where in the

Dimensions Row:  [Invoice Date]

Dimension Column: [Cash Application date]

Measures:  Sum([Cash Applied])

Resulting in:

I would like to create a total where I can see the totals for every invoice months, the cash applied.

If I write: rangesum(above(Sum([Cash Applied]),0,RowNo()))

I get this result:

Where I would like to RangeSum it on:

Rows:

Can you please help me.

Thanks

Ugur

[Steven_Haught]

@ugurarslan 

Try to use ColumnNo() instead of RowNo().

[ugurarslan]

Hi Steven,

When doing:

rangesum(above(Sum([Cash Applied]),0,RowNo()))

This is the result I get.

Is there something wrong in the expression I write?

Thanks Ugur

[sunny_talwar]

Try this

RangeSum(After(Sum([Cash Applied]), 0, ColumnNo()))

[ugurarslan]

Hi Sunny,

good to speak to you.

Unfortunaly that one didn't work also.

[sunny_talwar]

Do you have calculated dimension in there? Would it be possible for you to share the qvf file to look at this?

[ugurarslan]

Hi Sunny, 

this is what I have.

=
RangeSum(After(
(Sum({<[Type]={'APP'},[Cash App Type]={'CASH'},[INV Type]={'INV'},[Event Date]={">=$(=YearStart(AddYears(today(),-1)))<=$(=Current_Month_MTD)"}>}[AR USD])*(-1)/11)
,0, ColumnNo()))

Unfortunately it is enterprise qliksense, so no qvf file available.

Thanks

Ugur

[sunny_talwar]

The expression seems okay, but I am unable to make any sense of the output you are getting after using the expression I gave.... it is neither accumulated upwards, downwards, sidewards.... it just new set of numbers.... did you make a selection or remove a selection between the very first screenshot of your initial post and the one you used for my expression?