Current and Previous Month Sales Comaprison

[Anonymous]

Hi Friends,

             I have one problem ,my client requirements is sales report on basis of date filed ,suppose i selected Jan-2013

the current Month is Jan-2013 and Previous month is Dec-2012.

           i needed to display report structure like.

Date	Sales For Jan-2013	Sales For dec-2012
01-01-2013	2000	3000
02-01-2013	2500	4000
03-01-2013	2200	5000
04-01-2013	2100	2500
05-01-2013	5000	4500

what ever the Dec-2012 value are related to Dec month 01-12-2012,02-12-2012,03-12-2012,04-12-2012,05-12-2012.

same like for every month.

Please help me how to resolve the issue.

Thanks for your support.

Please find the test data for creating report,i want to calculate in UI only not is scripting part.

Thanks & Regards

SHAIK

[Anonymous · Accepted solution]

Hi tresesco,

     thanks for your support,it's working properly, but i needed another help,if i have sale is 0 then i want to take above sales value where value is available,i am sharing excel file,i added yellow color.

really thanks for your support,

Thanks

SHAIK

[Anonymous]

Hi tresesco,

    thanks for your support,it's working properly, but i needed another help,if i have sale is 0 then i want to take above sales value where value is available,i am sharing excel file,i added yellow color.

really thanks for your support,

please find the attachment of Excel file.

Thanks

SHAIK

[Anonymous]

Hi Sanket,

   Thanks for Your Support,currently i am using 11.2 version,

Thanks

SHAIK

[sanketkhunte]

Great !!

So you must have aware about Alternate State for Comparative Analysis.

[tresesco]

Try like:

If(Sales=0,Peek('NewSales'),Sales) as NewSales,

[Anonymous]

Hi tresesco,

             i want to calculate on UI only,not in back end script,peek will be work on back end only.please give the suggestion on Ui.

Thanks

SHAIK

[tresesco]

In UI, single 0/null value could be filled using above()/below() functions. But with multiple contigous rows to be filled with previous value ! - have to work on.

[Anonymous]

Hi tresesco,

         i know that above() and below() it wont support for loops,because if i created back end ,lower level hierarchy it wont be work,it's need to be work means i want to go for ledger concept,thanks for your help.

please if you know any suggestions on UI,please let me know.

Thanks

SHAIK