Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
I have requirement like below , in below table we can see Time Period. I want to show Time Period as Columns and show respected revenue for that time period.
Time_Period | Total Revenue | ID | QV_Date | Abc | CDE |
18 Months May2012-Oct2013 | 114603.954 | 1 | 7/31/2015 | 2 | 139 |
Apr-15 | 116.4 | 2 | 7/31/2015 | 2 | 103 |
Aug-13 | -3511.76919 | 3 | 7/31/2015 | 2 | 139 |
Aug-14 | 28068.82035 | 4 | 7/31/2015 | 2 | 139 |
Aug-14 | 4.052706201 | 5 | 7/31/2015 | 2 | 103 |
Current YTD | 9000 | 6 | 7/31/2015 | 2 | 139 |
Current YTD | 16100 | 7 | 7/31/2015 | 2 | 139 |
Current YTD | 454.15 | 8 | 7/31/2015 | 2 | 103 |
Current YTD | 709.83 | 9 | 7/31/2015 | 2 | 107 |
Current YTD | 347.65 | 10 | 7/31/2015 | 2 | 103 |
Dec-14 | 682.2468466 | 11 | 7/31/2015 | 2 | 103 |
Dec-14 | 48205.09874 | 12 | 7/31/2015 | 2 | 139 |
Feb-14 | 8011.51497 | 13 | 7/31/2015 | 2 | 139 |
Feb-15 | 375.15 | 14 | 7/31/2015 | 2 | 103 |
Jan-14 | 75206.01616 | 15 | 7/31/2015 | 2 | 139 |
Jan-15 | 9000 | 16 | 7/31/2015 | 2 | 139 |
Jan-15 | 79 | 17 | 7/31/2015 | 2 | 103 |
Jan-15 | 709.83 | 18 | 7/31/2015 | 2 | 107 |
Jul-13 | 41657.78445 | 19 | 7/31/2015 | 2 | 139 |
Jul-14 | 10029.85977 | 20 | 7/31/2015 | 2 | 139 |
Jul-14 | 77410.45768 | 21 | 7/31/2015 | 2 | 139 |
Jun-14 | 223.2450495 | 22 | 7/31/2015 | 2 | 103 |
Jun-14 | 100246.3363 | 23 | 7/31/2015 | 2 | 139 |
Mar-14 | 88834.30823 | 24 | 7/31/2015 | 2 | 139 |
Mar-15 | 16100 | 25 | 7/31/2015 | 2 | 139 |
Mar-15 | 231.25 | 26 | 7/31/2015 | 2 | 103 |
May-13 | 9027.179335 | 27 | 7/31/2015 | 2 | 139 |
May-14 | 637.1705961 | 28 | 7/31/2015 | 2 | 103 |
May-14 | 100236.0096 | 29 | 7/31/2015 | 2 | 139 |
Nov-13 | 6016.991937 | 30 | 7/31/2015 | 2 | 139 |
Nov-14 | 5308.531809 | 31 | 7/31/2015 | 2 | 107 |
Nov-14 | 240.5037763 | 32 | 7/31/2015 | 2 | 103 |
Oct-13 | 9037.446026 | 33 | 7/31/2015 | 2 | 139 |
Oct-14 | 630.1156618 | 34 | 7/31/2015 | 2 | 103 |
Oct-14 | 5017.731422 | 35 | 7/31/2015 | 2 | 139 |
Oct-14 | 4153.507468 | 36 | 7/31/2015 | 2 | 107 |
Oct-14 | 140.3393602 | 37 | 7/31/2015 | 2 | 103 |
Prior Full Year | 630.1156618 | 38 | 7/31/2015 | 2 | 103 |
Prior Full Year | 10029.85977 | 39 | 7/31/2015 | 2 | 139 |
Prior Full Year | 5247.170688 | 40 | 7/31/2015 | 2 | 103 |
Prior Full Year | 692577.941 | 41 | 7/31/2015 | 2 | 139 |
Prior Full Year | 9462.039277 | 42 | 7/31/2015 | 2 | 107 |
Q1 2012 | 9528.770293 | 43 | 7/31/2015 | 2 | 109 |
Q1 2012 | 2156.469785 | 44 | 7/31/2015 | 2 | 109 |
Q1 2014 | 172051.8394 | 45 | 7/31/2015 | 2 | 139 |
Q1 2015 | 9000 | 46 | 7/31/2015 | 2 | 139 |
Q1 2015 | 16100 | 47 | 7/31/2015 | 2 | 139 |
Q1 2015 | 454.15 | 48 | 7/31/2015 | 2 | 103 |
Q1 2015 | 709.83 | 49 | 7/31/2015 | 2 | 107 |
Q1 2015 | 231.25 | 50 | 7/31/2015 | 2 | 103 |
Q2 2012 | 1653.065077 | 51 | 7/31/2015 | 2 | 109 |
Q2 2013 | 9027.179335 | 52 | 7/31/2015 | 2 | 139 |
Q2 2014 | 200482.3459 | 53 | 7/31/2015 | 2 | 139 |
Q2 2014 | 860.4156456 | 54 | 7/31/2015 | 2 | 103 |
Q2 2015 | 116.4 | 55 | 7/31/2015 | 2 | 103 |
Q3 2013 | 96539.32868 | 56 | 7/31/2015 | 2 | 139 |
Q3 2014 | 10029.85977 | 57 | 7/31/2015 | 2 | 139 |
Q3 2014 | 266820.9256 | 58 | 7/31/2015 | 2 | 139 |
Q3 2014 | 3323.665059 | 59 | 7/31/2015 | 2 | 103 |
Q4 2013 | 15054.43796 | 60 | 7/31/2015 | 2 | 139 |
Q4 2014 | 630.1156618 | 61 | 7/31/2015 | 2 | 103 |
Q4 2014 | 1063.089983 | 62 | 7/31/2015 | 2 | 103 |
Q4 2014 | 9462.039277 | 63 | 7/31/2015 | 2 | 107 |
Q4 2014 | 53222.83016 | 64 | 7/31/2015 | 2 | 139 |
Rolling 12 Months | 5701.320688 | 65 | 7/31/2015 | 2 | 103 |
Rolling 12 Months | 977.7656618 | 66 | 7/31/2015 | 2 | 103 |
Rolling 12 Months | 26129.85977 | 67 | 7/31/2015 | 2 | 139 |
Rolling 12 Months | 10171.86928 | 68 | 7/31/2015 | 2 | 107 |
Rolling 12 Months | 529526.1017 | 69 | 7/31/2015 | 2 | 139 |
Rolling 18 Months | 5701.320688 | 70 | 7/31/2015 | 2 | 103 |
Rolling 18 Months | 977.7656618 | 71 | 7/31/2015 | 2 | 103 |
Rolling 18 Months | 26129.85977 | 72 | 7/31/2015 | 2 | 139 |
Rolling 18 Months | 10171.86928 | 73 | 7/31/2015 | 2 | 107 |
Rolling 18 Months | 707594.933 | 74 | 7/31/2015 | 2 | 139 |
Rolling 24 Months | 5701.320688 | 75 | 7/31/2015 | 2 | 103 |
Rolling 24 Months | 977.7656618 | 76 | 7/31/2015 | 2 | 103 |
Rolling 24 Months | 26129.85977 | 77 | 7/31/2015 | 2 | 139 |
Rolling 24 Months | 822198.887 | 78 | 7/31/2015 | 2 | 139 |
Rolling 24 Months | 10171.86928 | 79 | 7/31/2015 | 2 | 107 |
Rolling 36 Months | 5701.320688 | 80 | 7/31/2015 | 2 | 103 |
Rolling 36 Months | 977.7656618 | 81 | 7/31/2015 | 2 | 103 |
Rolling 36 Months | 26129.85977 | 82 | 7/31/2015 | 2 | 139 |
Rolling 36 Months | 822198.887 | 83 | 7/31/2015 | 2 | 139 |
Rolling 36 Months | 10171.86928 | 84 | 7/31/2015 | 2 | 107 |
Sep-13 | 58393.31342 | 85 | 7/31/2015 | 2 | 139 |
Sep-14 | 3319.612353 | 86 | 7/31/2015 | 2 | 103 |
Sep-14 | 161341.6476 | 7/31/2015 | 2 | 139 |
Required Output Needed
ID | Header 4 | Header 5 | Total Revenue | Jan 2014 | Feb 2014 | Mar 2014 | Apr 2014 | May 2014 | Jun 2014 | Jul 2014 | Aug 2014 | Sep 2014 | Oct 2014 | Nov 2014 | Dec 2014 | Jan 2015 | Feb 2015 | Mar 2015 | Apr 2015 | May 2015 | Jun 2015 |
0 | A | www | $6831.07 | $4387.76 | $2443.31 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
1 | Ba | 2ad | $390.13 | $269.75 | $120.38 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
2 | ww | assas | $2586.71 | $1516.37 | $1070.34 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
This you need on LOAD or in Presentation?
With your sample data (large table) the first columns ID, Header4, Header5 where are they come from?
By the way didn't you post this already? Show Last 18 Months Data
Regards
I am not sure how you have reached the output from the given data set you have provided above. May be if you can elaborate it a little, someone here might be able to help you better
Best,
Sunny
Hi Ashish,
Could you please post sample app.
Create a Pivot table with ID, Header4 , Header5 & TImePeriod as dimensions & required expressions.
Drag the TimePeriod to top like columns.
IS this not the same as your other POST? In which case, just use a pivot table
Andy