Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :)
On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa <p.dhamsa...@gmail.com> wrote: > Dear Mahreen > > Kindly find the attached file and see the yellow highlighted row ,i have > did the same w/o pivot > > > > On Thu, Jan 19, 2012 at 11:12 PM, Mahreen Ellahi <mahreen.acc...@gmail.com > > wrote: > >> Guys >> >> I have a range of data of which I want to plot a pivot table. My problem >> is that I have different expiry days but I want to club or group into >> certain buckets like <0 days,1- 30 days, 31-60 days etc. I dont want to >> take unexpired negative values in my pivot table. HELP NEEDED IN ATTACHED >> FILE. SAMPLE FORMAT ATTACHED BUT NOT AS A PIVOT TABLE. >> >> S # REGION BRANCH SEGMENT CUSTOMER NAME DATE OF APPROVAL ORIGINAL >> APPROVING AUTHORITY TOTAL FUNDED & NON-FUNDED LIMIT (IN MILLION) DATE OF >> INTERIM REVIEW ANNUAL REVIEW DATE VALIDITY / EXPIRY Days Expired 1 SOUTH >> I KHI CORPORATE ABC 07-Oct-2010 CC 50.000 31-Mar-2012 >> 31-Mar-2012 (90) 2 SOUTH I KHI COMMERCIAL DEF >> 23-Dec-2010 CC 300.000 31-Dec-2011 31-Dec-2011 1 3 SOUTH >> I KHI COMMERCIAL SDS 02-Feb-2011 CC 682.940 29-Feb-2012 28-Feb-11 >> 307 4 SOUTH I KHI CORPORATE FDFG 01-Nov-2010 CC 300.000 >> 31-Mar-2012 31-Mar-2012 (90) 5 SOUTH I KHI CORPORATE >> DFG 02-May-2011 CC 1,200.000 31-Mar-2012 31-Mar-2011 276 >> 6 SOUTH I KHI SME FDFG 25-Aug-2010 CC 375.000 31-Mar-2012 31-Mar-2012 >> (90) 7 SOUTH I KHI SME SDF 03-May-2011 CC 600.000 31-Mar-2012 >> 31-Mar-2010 641 8 SOUTH I KHI SME SDF 27-Jun-2011 CC 620.000 >> 30-Apr-2012 30-Apr-2012 (120) 9 SOUTH I KHI CORPORATE DSF >> 22-Mar-2011 CC 210.000 30-Apr-2012 30-Sep-2011 93 10 SOUTH >> I KHI CORPORATE SDF 23-May-2011 CC 471.000 30-Apr-2012 30-Apr-2012 >> (120) 11 SOUTH I KHI COMMERCIAL SDF 10-May-2011 CC 800.000 30-Apr-2012 >> 30-Apr-2012 (120) 12 SOUTH I KHI CORPORATE SDF 23-May-2011 CC >> 1,300.000 >> 31-Mar-2012 31-Mar-2012 (90) 13 SOUTH I KHI CORPORATE >> FDFG 13-Jul-2011 CC 1,300.000 31-Aug-2012 31-Aug-2011 123 >> 14 SOUTH I KHI SME DFG 24-Jun-2010 CC 1,200.000 30-Sep-2011 30-Sep-2011 >> 93 15 SOUTH I KHI CORPORATE DFG 18-Mar-2011 CC 400.000 31-Dec-2011 >> 31-Dec-2011 1 16 SOUTH I KHI SME FDFGSD 02-Nov-2011 CC >> 300.000 >> 31-Dec-2012 31-Jan-2009 1,065 17 SOUTH I KHI CORPORATE SDF >> 28-Mar-2011 CC 400.000 31-Mar-2012 31-Mar-2012 (90) 18 SOUTH >> I KHI COMMERCIAL SDF 23-Nov-2011 CC 900.000 31-Dec-2012 31-Dec-2012 >> (365) 19 SOUTH I KHI CORPORATE SDF 17-Jun-2011 CC 2,000.000 >> 30-Apr-2012 30-May-2011 216 20 SOUTH I KHI COMMERCIAL SDF >> 28-Mar-2011 CC 1,700.000 30-Apr-2012 30-Apr-2012 (120) >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
