Put a value in another row

[pgalvezt]

Hello,

I have a Pivot with dimensions: Group, Account SubAccount so on.

My exp are

Ene= Sum(Amount_01)

Feb=Sum(Amount_02)

So on until Sept

In the 5th row of my pivot I have a Value that I don´t want it. so I created: for March for example:

Sum({<Account={'32010310'},SubAccount-={'AR-01','AR-02'},Account-={'32010310'}>}Amount_03)

So the value is gone. But...

I want that this value be moved to the 9th row and calculated within others values.

How can I do that?

Thanks!

[Josh_Good]

Could you post a sample qvw please.

[pgalvezt]

I have created an Excel File (Simple) with what I want to obtain. Basically I need to change an account value to another row into my pivot. I wnat to move 1591364 to penultimate row. Below 1970218.

Thanks!

[Josh_Good]

What I'm seeing is a sorting issue.  Is that correct?  You could create a field that defines the sort order you want and then set the sort to look at that field.

[pgalvezt]

I think is not a problem of sorting. I want to move the value (With the same sorting actually) to penultimate row. Can QlikView do that. Is like in excel cut - paste.