Effective Pivot Point Calculator to help calculate effective pivot points for option traders, forex traders, bond. Enter these three and your calculation will appear. Excel Pivot tables is a great feature available in Excel that lets us summarize data in the spreadsheet. Using Pivot Tables we can reorganize, sort, count, total or give the average of the data stored in one table or spreadsheet, displaying the results in a second table what is the called “pivot table” and showing the summarized data.
- Points
- 30
- Posts
- 4
Hi All,I have a Pivot Table which has values of the count of employees in each Employee group, across regions/countries/offices, I need to find the ratio beteeen the total values of say Employee Group1 and Employee Group2. i.e. Ratio1 = Total Empgrp1/ Total Empgrp2.I have tried defining the rows as EmpGrp1 and EmpGrp2 and then dividing the two to get the ratio but being a Pivot Table, users expect to hide/show details of the Employee Group and also hide/show details of the Regions/countries etc. in such cases the defined names don't correspond to the values of the emp. groups and the ratios are not correct because the table shrinks/expands and is different from the original size.What is the best way to access the values of the total of an employee group across region values? Or to get the ratios?My second problem would be to dynamically update the ratios which i hope to address by using worksheet change macros.[I would be using an Add-in to write the formulas to the cells of the rows below the grand total.]I am attaching a worksheet with sample data. Please let me know if my question is not clear.Many thanks in advance.Sanjay- Navigation
- OzGrid
- Forum
- Members
- Options
- Current Location
This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.
- Points
- 93,501
- Posts
- 18,188
I've created a Pivot Chart in which I want to display travel by various folks to mulitple sites. The Site field is a Page field. If I set the Pivot Chart to a Custom -- Floating Bar style it displays fine, but if I change the Page field selection the chart reverts back to a stacked bar style.I've tried setting the default chart type to Floating Bar (this doesn't take), and naming a custom style that is Floating Bar (and setting the pivot chart to this custom style -- but again the style does not hold on a change to the Page field).I ran into this a few years ago and wrote some event macros to reformat the chart when the sheet is activated and when it calculates, but it seems there should be a simpler (built-in) way. Am I missing something obvious? Is there a way to make the Floating Bar style stick in a pivot chart without resorting to VBA updating?- Navigation
- OzGrid
- Forum
- Members
- Options
- Current Location
This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.