network profile
| bio | website | |
|---|---|---|
| location | Australia | |
| age | ||
| visits | member for | 1 year, 1 month |
| seen | Feb 5 at 0:37 | |
| stats | profile views | 12 |
|
Dec 11 |
comment |
Forecasting growth in pivot tables Yeah I realised that the pivot table wasn't actually appropriate for what I was trying to achieve. Excel's grouping function and a summary page was enough :P Also I don't know how to delete comments. Id like to upload the excel sheet for further explanation, but again, im not sure how to upload files, and the data is all sensitive. If there's enough interest in the question I may clean & upload the file... |
|
Dec 11 |
accepted | Forecasting growth in pivot tables |
|
Dec 3 |
awarded | Commentator |
|
Dec 3 |
comment |
Forecasting growth in pivot tables The reason I wanted to go to a pivot system is that the actual data is about 20 columns by 200 rows, needs to be disected in multiple dimensions (by year, by sub department, YoY growth, base growth, etc), and using a pivot system would save me having to manually create all the reports. On a side not, if you put 2nd comment as an answer rather than a comment I can close the thread as that essentially solved my original problem. Again, many thanks for the help in a poorly explained problem |
|
Dec 2 |
comment |
Forecasting growth in pivot tables From what I understand, if i project the growth rate using a formula with each year in a different column, if i then wanted to report on these caculation using pivot tables/charts, i would then need to alter the data so that it was in a normalised list (e.g. column titles would be 'year', 'units', 'cost') |
|
Dec 2 |
comment |
Forecasting growth in pivot tables Thanks for the heads up. So Do you then find that its a problem normalising the data after you have created the worksheet in a matrix formation? |
|
Nov 29 |
comment |
Forecasting growth in pivot tables Apologies. should have specified it is the growth (i.e. year on year units increase by 133 on average) |
|
Nov 29 |
asked | Forecasting growth in pivot tables |
|
Nov 20 |
accepted | Select multiple objects on top of simlanes |
|
Sep 13 |
answered | Select multiple objects on top of simlanes |
|
Sep 12 |
comment |
Select multiple objects on top of simlanes This solution does not really work in the context off rapidly adding new shapes, have multiple shapes in multiple groups, and having up to 100 shapes in a group. many thanks for the help, but i think this serves as more of an addition to the work around, but not a solution |
|
Sep 12 |
asked | Select multiple objects on top of simlanes |
|
Jun 8 |
comment |
Excel autosave versioning That macro is close. it saves the file, but i need it to return the file back to its original filename. Will modify and see if i can get it to work. The only thing im not sure how to do is to get the version number if it is not appended to the current workbook? Thankyou very much for pointing in the right direction. |
|
Jun 8 |
awarded | Scholar |
|
Jun 8 |
comment |
Excel autosave versioning Thanks for the quick reply. That code should do exactly what i want. My preferred option is dropbox, but our silly group policy forbids it ('security issues'). Cheers! |
|
Jun 7 |
asked | Excel autosave versioning |
|
May 28 |
comment |
Refreshing Crystal Reports through Excel Macro Will do. When i originally found the answer i did not have enough rep to answer my own question. Will provide a more detailed answer below |
|
May 24 |
awarded | Student |
|
May 17 |
comment |
Refreshing Crystal Reports through Excel Macro To resolve the issue, i created an odbc connection to the database and used the data sources tab in excel to directly import the data into excel |
|
May 9 |
awarded | Tumbleweed |
