order by month year and activity

[fkeuroglian]

Hi expert i have this qvd i want to order by month year and activity

see the attached image that i have now in my qvd.

i want to create a sort like this in the script:

01-2011 FreeShop

02-2011 FreeShop

03-2011 FreeShop

04-2011 FreeShop

05-2011 FreeShop

06-2011 FreeShop

07-2011 FreeShop

08-2011 FreeShop

09-2011 FreeShop

10-2011 FreeShop

11-2011 FreeShop

12-2011 FreeShop

01-2011 Retail

02-2011 Retail

03-2011 Retail

04-2011 Retail

05-2011 Retail

06-2011 Retail

07-2011 Retail

08-2011 Retail

09-2011 Retail

10-2011 Retail

11-2011 Retail

12-2011 Retail

I have 4 differentes activityies and i want to create and order MONTHYEAR and then Activity

i try to put order by MonthYear, Activity but my order is like the image attached

i attached the .qvd

thank for any helps

Fernando K.

[tamilarasu · Accepted solution]

Hi Fernando,

Check the attachment !.

[fkeuroglian]

Thank you Tamil!

works great

Fernando K.

[tamilarasu]

You are welcome Fernando.

[fkeuroglian]

Hi Tamil,may be you have the solution to this! thanks a lot

I want to use the peek function to acumulutae values in the script, and if i do not have value to one month, take the acumuluate and create a value that bring the previous (peek) value that i have in the table

for example

Retail  01-2010  100

Retail  02-2010  0

Retail  03-2010  50

Bank    01-2010  140

Bank    02-2010  0

I want something like this

Retail  01-2010  100

Retail  02-2010  100

Retail  03-2010  150

Bank    01-2010  140

Bank    02-2010  140

i attached and image that i have result and the qvd is simple only few register and field

i am using the peek, but i am sure i have an errror

thank you a lot

Fernando K.

[tamilarasu]

Hi Fernando,

I am not near to my system. Anyhow, you can try something like below

If(rowno()=1,Sales,

       If(Peek(Type)=Type and Peek(Year(DateField))=Year(DateField), Peek(Sales)+Sales)) as TotalSum

Replace the column name sales to your desired column.

Give a try and let me know.