Kenneth Barber
My feedback
-
1 vote
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
What if you have more than 2 lines? What if the order of the lines changes?
Subtraction is just the addition of negative numbers. In your data source, add a new column that keeps the minuends the same and negates the subtrahends. Use this new column in your PivotTable and summarize with Sum.
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
What do you mean by that?
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
You can use conditional formatting to make the font colour match the colour of the background when the value is 0. You can also just filter out the 0 values.
-
3 votes1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Your suggestion is fairly specific to your case. You should be able to automate this by using macros. The macro would do something like this: for each organization, filter the PivotTable for only that organization's data, copy and paste the values of the PivotTable into a new file, and save that new file.
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Why would you make a PivotTable based on what used to be a PivotTable? It sounds like you are overcomplicating your math and workflow by adding in lots of unnecessary intermediate steps.
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Is that cell manually formatted by mistake?
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
PivotTable show aggregated data (e.g. sum, max, min, average), not raw data, so your suggestion doesn't make sense. Also, all PivotTables are based on some data source. Why not edit the data source to produce the desired PivotTable?
-
2 votes0 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
In what case would you need 2 identical Power Query tables, each with their own copy of the query?
-
1 vote2 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Can you be any more vague?
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Can an admin please delete this? It is a mistitled version of this:
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/37171057-need-a-normal-filter-option-for-pivot-tables -
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Instead of trying to add a PivotTable to the Data Model, use Power Query (Get & Transform) to make your "PivotTable" and add that to the Data Model.
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Put your data in a table (available on the Insert tab) and base your PivotTable on that. Or use column references (e.g. A:F) instead of cell references (e.g. A1:F300) when you make your PivotTable. This way, you don't need to select a range so often that you want a shortcut for it.
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Put your dates along the rows or columns. Right-click on them and click on Group. You will have access to all of the groupings that you mentioned except for weeks, and you can select multiple items at once. Once you have applied the group, you can move around the different components of the date.
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
Right-click on your PivotTable, go to PivotTable Options, go to the General tab, and make sure that "Preserve cell formatting on update" is checked.
-
1 vote
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
If your PivotTable is set up so that more than 1 source cell goes to the same PivotTable cell, you need to specify how to deal with the clash. This is why you need to choose sum, max, min, etc. If you are using Power Pivot, you can go IF(HASONEVALUE('Table'[Column]),VALUES('Table'[Column])).
If your PivotTable is meant to rearrange rather than summarize data, why not do away with the PivotTable and just use normal cells and formulas? If you're worried about the row and column headings being dynamic, dynamic arrays are just around the corner and should solve that problem beautifully.
-
1 vote1 comment · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
This should be moved there:
https://excel.uservoice.com/forums/304936-excel-for-mobile-devices-tablets-phones-android
Using 2 PivotTables (1 for use as a PivotTable and 1 as the source of the PivotChart) is actually your best bet. If you really want, add your table to the Power Pivot Data Model. Then both your PivotTable (the one for use as a PivotTable) and your PivotChart would be based on the version of the table in the Data Model. PivotCharts based on the Data Model don't need a corresponding PivotTable.