Feedback by UserVoice

Kenneth Barber

My feedback

  1. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    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.

  2. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    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.

  3. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    What do you mean by that?

  4. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    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.

  5. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  6. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    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.

  7. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    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.

  8. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Is that cell manually formatted by mistake?

  9. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    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?

  10. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber supported this idea  · 
  11. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    In what case would you need 2 identical Power Query tables, each with their own copy of the query?

  12. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    Can you be any more vague?

  13. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 
  14. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    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.

  15. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    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.

  16. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    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.

  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    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.

  18. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

  19. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

    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.

  20. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Kenneth Barber commented  · 

Feedback and Knowledge Base